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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.
ASK Questions
SQL Server NodeJs TypeScript JavaScript Angular SQL Server My Book