Monday, April 30, 2012

[traces] Killing orphaned trace

Swore I had this already.



SELECT * FROM sys.traces

sp_trace_setstatus 2, 0 --stop trace 2
go
sp_trace_setstatus 2, 2 --close/remove trace 2