Steve Hebert's Development Blog

Sponsors

The Lounge

Wicked Cool Jobs

Syndication

Recent Posts

Tags

View more

Currently Reading

My Amazon Wish List

Archives

Advertisement

Steve Hebert's Development Blog » Sql2k5 and fn_trace_getinfo
Images in this post missing? We recently lost them in a site migration. We're working to restore these as you read this. Should you need an image in an emergency, please contact us at imagehelp@codebetter.com
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.


Posted Thu, Jun 15 2006 11:10 AM by shebert

[Advertisement]

Comments

Paul Czywczynski wrote re: Sql2k5 and fn_trace_getinfo
on Thu, Jun 15 2006 12: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
Darshan Singh wrote re: Sql2k5 and fn_trace_getinfo
on Thu, Jun 15 2006 4: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).

SCarpenter wrote re: Sql2k5 and fn_trace_getinfo
on Thu, Jun 15 2006 8:00 PM
I believe this would be the new default trace functionality in SQL Server 2005 - http://msdn2.microsoft.com/en-us/library/ms175513.aspx.
WebGyver » Blog Archive » SQL Server :: Profiler :: Open Traces wrote WebGyver » Blog Archive » SQL Server :: Profiler :: Open Traces
on Sat, Sep 2 2006 4:39 PM
PingBack from http://www.humdinger-media.com/wblog/?p=4
Devlicio.us