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