Post reply

existing server side traces

  • March 2, 2007 at 10:37 am

    #68194

    I've found some traces running on our server.  I'd like to find out where they are saving the file or table to.  how can I do this?  All I've found so far is how to change the status etc. using the sp_trace_setstatus and other sp's.

    thanks

    sam

  • March 5, 2007 at 1:45 am

    #693037

    ask whoever set the traces ?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • March 5, 2007 at 1:02 pm

    #693196

    "I've found some traces running on our server. I'd like to find out where they are saving the file or table to. how can I do this? "

    select * from :: fn_trace_getinfo(default)

    SQL = Scarcely Qualifies as a Language

  • March 5, 2007 at 1:59 pm

    #693207

    thanks - after looking more closely i see why I missed it.  There are nulls in the filename field - so these traces are not being saved to a file.  thanks Carl.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply