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
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
Comments