SQL Server Profiler

• by Rob Wagner, Implementation Specialists

The scenario here,  is that you want to capture all activity on the SQL Server for a particular Dynamics GP user.  

Here are the steps to do so.

1. From the SSMS (SQL Server Management Studio), choose Tools from the menu and select SQL Server Profiler.
2. Connect and then select the Events Selection tab, depicted below.
3. Click Show all columns and Show all events, then scroll to the bottom of the window.
4. Select the following options
   • TSQL - SQL:StmtStarting
   • TSQL - SQL:StmtCompleted
   • Stored Procedures - SP:StmtStarting
   • Stored Procedures - SP:StmtCompleted
5. Click on Column Filters, and find LoginName
   • Enter the login name for you with to capture statements
6. Click Run

The SQL Server Profiler will show the start and end for each statement in both TSQL and SP (stored procedures). You can use this tool to quickly find out what is happening for a particular user at any particular time.

Hope you found this useful!

At Implementation Specialists, we have the technical resources to answer questions and provide assistance around any type of data integration.  Please give us a call at 218-486-5095 or email me at deb@iscorp.biz if you need help.

By Deb Sletmoen, MCT, Implementation Specialists – Microsoft Dynamics GP Gold Partner with Advanced ERP Competency and Source Code Provider