SQLTeam.com | Weblogs | Forums

Server Side Trace gone after restart


#1

I was using a Server-Side trace to log some Stored Procedure Calls. After a few months, I did select * from sys.traces and my trace is gone! I found in msdn just now that traces are removed after a re-start.

Is there any option or solution so that server-side traces are not removed during a restart?


#2

You have to recreate the trace every time the system restarts - create an agent job that starts the trace and set the schedule to execute every time SQL Server agent starts.