CodeBetter.Com
Sign in | Join | Help
in Search
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.



Published Jun 15 2006, 11:10 AM by shebert

Comments

Paul Czywczynski said:

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
# June 15, 2006 12:54 PM

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

About CodeBetter.Com

CodeBetter.Com FAQ
Our Manifesto
Advertisers should contact Brendan

Subscribe

Google Reader or Homepage
del.icio.us CodeBetter.com Latest Items
Add to My Yahoo!
Subscribe with Bloglines
Subscribe in NewsGator Online
Subscribe with myFeedster
Add to My AOL
Furl CodeBetter.com Latest Items
Subscribe in Rojo

Member Projects

WSMQ - Brendan Tompkins
Sarasota Web Design - David Hayden
Patterns & Practices - David Hayden
dotMath - Steve Hebert
EZWeb - Jeffrey Palermo
Structure Map - Jeremy D. Miller
StoryTeller - Jeremy D. Miller
The Code Wiki - Karl Seguin

 

Friends of CodeBetter.Com

Red-Gate Tools For SQL and .NET
 BlogJet
CodeSmith 3.0
 SourceGear Vault
Telerik
 ComponentArt
VistaDB
JetBrains - ReSharper
 Beyond Compare
 .NET Memory Profiler
NDepend
AliCommerce
Ruby In Steel
SlickEdit
SmartInspect .NET Logging
NGEDIT: ViEmu and Codekana
LiteAccounting.Com
DevExpress <-- NEW Friend!


Site Copyright © 2007 CodeBetter.Com
Content Copyright Individual Bloggers

Community Server (Commercial Edition)