SQL Server Profiler... Capture it all!

Visit Website View Our Posts

 

  • with 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 [email protected] if you need help.

 

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

Leave a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Show Buttons
Hide Buttons