Is there a quickstart guide on how to configure SQL profiler for SQL 2005? I am using a shared database, so I want to only view queries that are executed by my application.
A:
You can filter by things like ApplicationName or LoginName
Trace Properties Events Selection tab Column Filters Button.
Gratzy
2010-06-29 16:04:29
+1
A:
On the Trace Properties, 'Events Selection' tab, there is a Button named 'Column Filters..'
Click on this button launches a dialog where allows you to filter your profiling.
One of the filters is called ApplicationName.
Click on 'ApplicationName' item on the left and you get right hand side pane with Treeview Node where you can type in the name of your application in the 'Like' Node
Just found this documentation on MSDN
J Angwenyi
2010-06-29 16:04:41