Turn off default tracing in SQL Server

SQL Server 2005 runs a default trace. Run this query to determine if tracing is enabled:

SELECT *
FROM fn_trace_getinfo(default);
GO

This yields the result set below, where property 5 ("Current Trace status") is set to a value of 1 (where "1" means on and "0" means off).



To turn off default tracing, run this query:

sp_configure 'default trace enabled', 0

To reenable it, run this query:
sp_configure 'default trace enabled', 1