Detecting a Trace 1

[bikerboy718]

Is there a way for me to tell if a trace is being run on a sql server?

With Great Power Comes Great Responsibility!!!

Michael

 

[ptheriault]

If it's sql 2005 by default it is always running a trace. Check the log folder of your install directory.


- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

If SQL 2005 you can view the running traces using the sys.traces DMV.

select *
from sys.traces

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[bikerboy718]

Thanks mrdenny. That was exactly what I was looking for.



With Great Power Comes Great Responsibility!!!

Michael