Developer Mode

Who created the Audit Trace? If it is the C2 Audit, you have to use sp_configure to turn it off: EXEC sys.sp_configure N'c2 audit mode', N'0' GO RECONFIGURE WITH OVERRIDE GO You can check if it is enabled by just running: EXEC sys.sp_configure N'c2 audit mode' Look at the run_value returned if it is 1 then the C2 Audit is running and that is your problem. Find out why it was enabled and what for. You might not be able to just disable it. You can read more about the C2 Audit on the following Article: http://technet.microsoft.com/en-us/library/dd277388.aspx -------------------------------------------------------------------------------- Jonathan Kehayias http://sqlblog.com/blogs/jonathan_kehayias/ http://www.twitter.com/SQLSarg http://www.sqlclr.net/ Sumber: http://social.msdn.microsoft.com/Forums/en-SG/sqldatabaseengine/thread/3d485a94-eef0-4890-a68f-acbd73be1c65

The filename is "audit trace". That makes me think that it is auditing everything that could potentially be important against your SQL Server. Some companies need this for SOX compliance. If you know this does not apply to your SQL Server environment, you can turn it off by issuing T-SQL commands. To view all of the traces on your system, run this: SELECT * FROM sys.traces WHERE path LIKE N'%audittrace_%' Find the trace that is called audittrace.trc: --Stop the trace EXEC sp_trace_setstatus @traceid = , @status = 0 --Delete the trace definition from the server EXEC sp_trace_setstatus @traceid = , @status = 2 Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ Sumber: http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/2b5bac33-03a6-46c7-a83e-c36e09ae8a33/