Discussion in 'Getting Started' started by lara99, Oct 10, 2007.
Is there a way to see the traces set on a particular instances.
Are you talking about sql2005 default traces? if so, yes, they will be in different directories like:
What Mike referred is best one to go to see the basic processing information, if you need further dig out on a specific set of queries then PROFILER or server side trace using SPs will help you a lot.
But be clear on what you want.
Thank U guys, for the reply, I was asking like is there any command in QA which give us the present trace enabled not the default one but user defined - user defined in the sense set by the person who is interacting with QA , I hope I am clear enough Thanku.
SELECT * FROM fn_trace_getinfo(0) to view the data in that trace file, formore information on what users are running SP_WHO2 will get you more.
Separate names with a comma.