Switch to SQL Profiler, on the File menu, click Stop Trace. Run Microsoft Dynamics SL until you complete the event that you want to trace.
Switch to SQL Profiler, on the File menu, click Run Trace. Run Microsoft Dynamics SL to the point before the event that you want to trace. On the General tab, select KB967955_SQL2008 (user) in the Use the template: box, and then click Run. SQL Server Profiler - File C:\Documents and Setting\username\Desktop\KB967955_SQL2008.tdf was imported successfullyĬonnect to the server that is hosting the Microsoft Dynamics SL databases. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.ĭouble-click the KB967955_SQL2008.tdf file, and then click OK when you receive the following message: Microsoft used the most current virus-detection software that was available on the date that the file was posted. The following file is available for download from the Microsoft Dynamics File Exchange Server:
To use SQL Profiler in SQL Server 2008 to trace database events in Microsoft Dynamics SL, follow these steps:ĭownload, and then save the KB967955_SQL2008.tdf file on the desktop of the computer that is running SQL Server 2008. Advanced Search can be found on the CustomerSource Home Page and the PartnerSource Home Page, or by using one of the following links: You can also use the Advanced Search functionality to find information throughout CustomerSource or PartnerSource, including the Knowledge Base. As this document contains informational or ‘how to’ related material, we have moved the document to one of the following areas:
Knowledge Base articles are intended to provide reactive, troubleshooting help.
#Sql management studio 2008 r2 download how to
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. BUG #: 109680 (Content Maintenance) INTRODUCTION