WordCustomRefiner2#afd1ca55-403d-404c-b60c-692906bef937
WordCustomRefiner3#cb001ab7-1f19-4da1-8860-3e04d243802c

How to Use SQL Profiler in SQL Server 2012 to Trace Database Events in Microsoft Dynamics SL

Last Modified Friday, February 20, 2015
Top Solution

Download

This article describes how to use Microsoft SQL Profiler in Microsoft SQL Server 2012 to trace database events in Microsoft Dynamics SL 2011 and later versions.

Sign In Popup
Lock Icon

The content of this page is locked.

To access this information log in to CustomerSource.

Unable to log in to CustomerSource?

Visit our CustomerSource Help Page.

Close

Lock Icon

The content of this page is locked.

To access this information log in to CustomerSource.

Unable to log in to CustomerSource?

Visit our CustomerSource Help Page.

Lock Icon

Your current service plan does not allow access to this information.

To learn more about Microsoft Dynamics Service Plans review our
service plan offerings.

Introduction

This article describes how to use Microsoft SQL Profiler in Microsoft SQL Server 2012 to trace database events in Microsoft Dynamics SL 2011 and later versions.

More Information

Microsoft SQL Server 2012:

To use SQL Profiler in SQL Server 2012 to trace database events in Microsoft Dynamics SL, follow these steps: 

  1. Download, and then save the SLSupport_SQL2012.tdf  file on the desktop of the computer that is running SQL Server 2008.

    The following file is available for download from the Microsoft Dynamics File Exchange Server: SLSupport_SQL2012.tdf
    Release Date: December 28, 2012
    Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

  2. Double-click the SLSupport_SQL2012.tdf  file, and then click OK when you receive the following message:
    SQL Server Profiler - File C:\Documents and Setting\username\Desktop\SLSupport_SQL2012.tdf was imported successfully
  3. On the File menu, click New Trace.
  4. Connect to the server that is hosting the Microsoft Dynamics SL databases.
  5. On the General tab, select SLSupport_SQL2012 (user) in the Use the template: box, and then click Run.
  6. On the File menu, click Pause Trace.
  7. Start Microsoft Dynamics SL. Run Microsoft Dynamics SL to the point before the event that you want to trace.
  8. Switch to SQL Profiler, on the File menu, click Run Trace.
  9. Run Microsoft Dynamics SL until you complete the event that you want to trace.
  10. Switch to SQL Profiler, on the File menu, click Stop Trace.

Note You can view the trace results on screen. You can also save the trace results to a file. You can then send the file to Technical Support for Microsoft Dynamics SL.

A video is also available that steps through the process of running the a SQL Profiler trace. 

For information about technical support for Microsoft Dynamics SL, visit the following Microsoft Web site:
http://www.microsoft.com/dynamics/support/default.mspx

References 

For more information about how to trace database events in earlier versions of Microsoft SQL Server, click the following articles :

https://mbsauthor.partners.extranet.microsoft.com/sites/CSSL/northamerica/Learning/Pages/SLSQL2012Trace.aspx
No
SL 2011