Yesterday we had a long running trace take up too much space on disk. To find the running trace, look for the location of the file to identify your trace, and get the id:
SELECT * FROM sys.traces
Next, disable and delete the trace with the @status option = 2:
EXEC sp_trace_setstatus @traceid = # , @status = 2
Use option 0 = disable, 1 = start, 2 = disable and delete.
Have fun with traces, but make sure to stop them before you go home for the weekend!
