Sql2k5 and fn_trace_getinfo

Posted by stevehebert on June 15, 2006

I blogged some time back about detecting running traces on Sql2000.

You can detect a running trace on a server by using the line:
select * from :: fn_trace_getinfo(default)

It turns out that Sql2k5 is always reporting a running trace.  At this point, I’m not certain why that is.  When I learn more, I’ll post.

This entry was posted in Uncategorized. Bookmark the permalink. Follow any comments here with the RSS feed for this post.

3 Responses to Sql2k5 and fn_trace_getinfo

  1. SCarpenter says:
    June 16, 2006 at 12:00 am

    I believe this would be the new default trace functionality in SQL Server 2005 – http://msdn2.microsoft.com/en-us/library/ms175513.aspx.

  2. Darshan Singh says:
    June 15, 2006 at 8:48 pm

    See “default trace enabled Option” in Books online. Also see http://www.informit.com/articles/printerfriendly.asp?p=457500 (under Dynamic Management Views heading).

  3. Paul Czywczynski says:
    June 15, 2006 at 4:54 pm

    I came across this about a month ago, it might help you out.. (Thankfully I archived it)

    http://sqljunkies.com/WebLog/mz1313/archive/2006/05/09/20962.aspx

Leave a Reply