Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Trace stopped...SQL Trace was started

Author  Topic 

Starting Member

16 Posts

Posted - 2010-07-13 : 09:59:22
Hello we where experimenting with SQL Profiler server side traces yesterday..this morning i check the application log on the server and all i see is a bunch of

"SQL Trace ID 2 was started by login.."

followed by

"SQL Trace stopped. Trace ID = '2'.Login Name =.. "

like 4 of those every minute ..any idea on how to make this madness stop.


Almighty SQL Goddess

38200 Posts

Posted - 2010-07-13 : 13:14:12
Explain what you did in your experimentation. It sounds like SQL jobs were setup to stop/start traces constantly.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server

Subscribe to my blog
Go to Top of Page

- Advertisement -