Pages

Sunday, June 24, 2012

SQL Server 2008 Profiler - How to filter trace to only display events from one database ?


Create New template and follow below steps on "Trace Properties" window-

1 - Click on the "Events Selection" tab
2 - Click on the "Show All Columns" check box
3 - Click on the "Column Filters..." button
4 - Select "DatabaseName", click on the plus icon to Like in the right-hand side pane, and type your database name.

Thanks

No comments:

Shared Button