Trace queries with SQL Server Profiler

  1. Launch SQL Profiler and connect to the SQL server
  2. Go to Events Sections and check "Show all columns"
  3. Click "Column Filters" button
  4. On DatabaseName, put your database name or %DBName% for wildcards
  5. On TextData and put in " %TableName%" or/and " %OtherCriteria%". You can place as many as you want.
  6. Press OK to close "Edit Filter" dialog and press Run 
  7. Do not forget to stop trace.

 

Search

About

DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics AX.

Authors are allowed to set their own AdSense units and "buy me a coffee" link.
Join us.

Blog Tags