How do I use sp_configure on SQL 2005 (full edition) to disable these 200MB mulithreaded traces that are going on in the background and filling up my hard drive?
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\audittrace_20061029095619_4.trc
Thanks for the answer. Here was the fix:
c:\> osql -E > sp_configure 'show advanced options', 1 > go > RECONFIGURE > go > sp_configure 'c2 audit mode', 0 > go > RECONFIGURE > go Then restart SQL server.