15 Best SQL Queries for Developers [SQL Queries]

SQL Server Profiler Trace Events For a Specific Database 2012

How to SQL Server Profiler Trace events only a Specific database”?
In this post, I am sharing to the “SQL Server Profiler Trace events only a specific database” step by step with YouTube video link. It is very helpful to me and you also.

Actually, I always forget how to configure SQL Server Profiler to trace only a specific database.

Steps for SQL Profiler Trace as,
1.      Open SQL Profiler.
2.      Click on the “New Trace”.
3.      Connect to your “Database Server” for Trace.
4.      The “Trace Properties” window and after click “Events Selection” tab.
5.      Click on check the checkbox “Select all columns” options.
6.      And after scroll event trace window on right side and find the database “column name”.
7.      And after click on “database name” check box to trace the events like Session, Store Procedure and T-SQL etc.
8.      And after click on “Column Filters..” button and open the “Edit Filter” popups.
9.      And after click on “database name” filter text.
10. And after click on “like” text and add your “database name” for tracing the events.
11. And click on Edit Filter “Ok” button.
12. And click on “Run” button o “Trace Property” window.
13. Finally, see the result on the “Untitled -1” window.

The Steps window for SQL Server Profiler Trace as,

I hope you are enjoying with this post! Please share with you friends. Thank you!!

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

www.code-sample.com/. Powered by Blogger.