Wednesday, 21 May 2014

How to set up SQL Server Profiler to show SELECT, UPDATE, INSERT and DELETE commands

Start a New Trace (go to File / New Trace), or even better: go to File / Templates / New Template to create a new template once and for all.

To make things easier, base your new trace on an existing Trace Template: the best one to use is Tuning (see screen shot below).

Go to the Events Selection tab (see screen shot below).

Tick Show all events and Show all columns so that you can find the information you need.

Make your selections look like the screen shot below.

Click the Column Filters button (bottom right).

Click on TextData and set filters as shown in the screen shot below. You may also need to put a % in front of each word.

OK your settings and click Run.

No comments:

Post a Comment