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
Monday, April 30, 2012
Subscribe to:
Posts (Atom)
Put butter in your mixer, add sugar, set on low. Write a stored procedure to keep track of jobs that won't run. Add flour. Use a DMV to find unused indexes. Add eggs. Bake in an MDF with 20% free space.