How to use SQL Profiler in SQL Server 2008, 2008 R2, 2012 or 2014 to trace database events in Microsoft Dynamics SL

Applies to: Dynamics SL 2011

INTRODUCTION


This article describes how to use Microsoft SQL Profiler in Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 to trace database events in Microsoft Dynamics SL 7.0 Service Pack 1 (SP1) and later versions. 

Notice

Knowledge Base articles are intended to provide reactive, troubleshooting help. As this document contains informational or ‘how to’ related material, we have moved the document to one of the following areas:

CustomerSource: https://mbs.microsoft.com/customersource/documentation/howtodocuments/MSDSLSQLServer2008R2_Howto
PartnerSource: https://mbs.microsoft.com/partnersource/documentation/howtoarticles/MSDSLSQLServer2008R2_Howto

You can also use the Advanced Search functionality to find information throughout CustomerSource or PartnerSource, including the Knowledge Base. Advanced Search can be found on the CustomerSource Home Page and the PartnerSource Home Page, or by using one of the following links:

PartnerSource: https://mbs.microsoft.com/partnersourceapp/search.aspx?st=a
CustomerSource: https://mbs.microsoft.com/customersourceapp/search.aspx?st=a

More Information


Microsoft SQL Server 2008:


To use SQL Profiler in SQL Server 2008 to trace database events in Microsoft Dynamics SL, follow these steps: 
  1. Download, and then save the KB967955_SQL2008.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:



    Release Date: February 16, 2009




    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 KB967955_SQL2008.tdf file, and then click OK when you receive the following message:
    SQL Server Profiler - File C:\Documents and Setting\username\Desktop\KB967955_SQL2008.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 KB967955_SQL2008 (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.


Microsoft SQL Server 2008 R2:

To use SQL Profiler in SQL Server 2008 R2 to trace database events in Microsoft Dynamics SL, follow these steps:
  1. Download, and then save the KB967955_SQL2008R2.tdf file on the desktop of the computer that is running SQL Server 2008 R2. 

    The following file is available for download from the Microsoft Dynamics File Exchange Server:

    Release Date: August 23, 2010

    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 KB967955_SQL2008R2.tdf file, and then click OK when you receive the following message:
    SQL Server Profiler - File C:\Documents and Setting\username\Desktop\KB967955_SQL2008R2.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  KB967955_SQL2008R2 (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.

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 2012.

 The following file is available for download from the Microsoft Dynamics File Exchange Server: 

SLSupport_SQL2012.tdf

  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.


Microsoft SQL Server 2014:

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


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

 The following file is available for download from the Microsoft Dynamics File Exchange Server: 

SLSupport_SQL2014.tdf

  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_SQL2014.tdf file, and then click OK when you receive the following message: SQL Server Profiler - File C:\Documents and Setting\username\Desktop\SLSupport_SQL2014.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_SQL2014 (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.

For information about technical support for Microsoft Dynamics SL, visit the following Microsoft Web site:

solomon

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE.

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.