Running Traces: how do I create a list in QA?

• dde

  SSC Eights!

  Points: 891

  More actions

  November 16, 2007 at 9:20 pm

  #153969

  Most people would use a GUI to create and view running traces. I did not know I could create (start, stop, delete too) executing this:

  sp_trace_create

  So, I created a trace in query analyzer, I can see the file and it is growing.

  But, how can I see a list of running traces in case there are many? Is there a command that displays this list in case I have several traces running?

• dde

  SSC Eights!

  Points: 891

  More actions

  November 16, 2007 at 9:27 pm

  #752034

  Well, I was expecting another sproc, turns out this functions does it, I guess (have not tried it)

  SELECT * FROM :: fn_trace_getinfo(default)

  I think I like it better as in SQL 2005: there is a sys.traces replacing the fn_trace_getinfo function.