CodeBetter.Com
CodeBetter.Com
RSS 2.0 via Feedburner
           Do you Twitter? Follow us @CodeBetter

Steve Hebert's Development Blog

Steve's Blog - From .Net to dotMath and everything in between.

Sql2k5 and fn_trace_getinfo

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.




Comments

Darshan Singh said:

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

# June 15, 2006 4:48 PM

SCarpenter said:

I believe this would be the new default trace functionality in SQL Server 2005 - http://msdn2.microsoft.com/en-us/library/ms175513.aspx.
# June 15, 2006 8:00 PM

WebGyver » Blog Archive » SQL Server :: Profiler :: Open Traces said:

PingBack from http://www.humdinger-media.com/wblog/?p=4
# September 2, 2006 4:39 PM
Check out Devlicio.us!

Our Sponsors