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/

Today I installed URLScan 2.5 and experienced following error: “The Web Server Has Been Locked Down and Is Blocking the DEBUG Verb” while I tried to debug my project. I tried several thing apart from restarting my IIS, but nothing worked ! " UrlScan version 2.5 is a security tool that restricts the types of HTTP requests that Internet Information Services (IIS) will process. By blocking specific HTTP requests, the UrlScan security tool helps prevent potentially harmful requests from reaching the server. UrlScan 2.5 will now install as a clean installation on servers running IIS 4.0 and later." Then I tried developers' best friend yes, Google! , and I got the solution from microsoft site. -------------------------------------------------------------------------------- To enable debugging on a Web server with URLScan installed 1.Locate the Urlscan.ini file. Normally, you will find it in a directory that looks something like this: %windir%\System32\Inetsrv\urlscan2.Create a ...