How to configure sql server profiler to see sql for my session only

[Tridip Bhattacharjee]

suppose i am working with SSMS and issuing many sql but sql server profiler will show all sql hiting database. so tell me how to configure sql server profiler to see my issued sql only. suppose i have developed c# apps which calling store proc or issuing in line sql. so tell me in this scenario how could i configure sql profiler to see what sql my desktop application is issuing ? guide me in details or get me a article link which help me to configure sql server profiler to see sql issued by my desktop apps. thanks

tbhattacharjee

[Lost User]

Tridip Bhattacharjee wrote:

guide me in details or get me a article link

Please do your own research: that is what Google is there for.

[Lost User]

You can filter the results. MSDN has a list of the columns and their use :)

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

[Tridip Bhattacharjee]

i found it...here it is Under Trace properties > Events Selection tab > select show all columns. Now under column filters, you should see the USERNAME name. Give username in following fig. [screen shot image]

tbhattacharjee