How do I create a trace statement in SQL Profiler

How do I create a trace statement in SQL Profiler

Step 1

To create a trace statement in SQL Profiler, go to Start ,choose Programs then select Microsoft SQL Server. After that click on Profiler

Step 2

When a new window appear choose File and select New Trace or CTRL+N

Another window will appear

Step 2

Verify the username and password is valid .Then click OK to continue.

Step 3

We will call this trace TestDemo. Under the Trace Name, enter TestDemo.

Then click on Events tab.

We will now determine which database Event we would like to handle. Here we perform tracing on TSQL transactions.

Step 4

Click OK.

The newly created trace would report a list of transaction that involve BEGIN TRANS, COMMIT, SAVE and ROLLBACK status.