python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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!!

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - and
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like Powered by Blogger.
ASK Questions