how to disable a Server AUDIT? i keep getting error ---> Disable failed "Lock request time out period exceeded. (MS SQL srvr Error 1222)

Question

every time I enable a server audit in SSMS under Security Audit, I can not disable the audit. I have to shut down SQL services, and restart them and remove the Audit first thing...

SQL 2008 R2 sp1

Answer 1

this is under "Server Audit Specification"

 

If I run a script to disable it, the script runs forever...

Answer 2

Everything time i try to disable the server audit, i get an error msg above... I also tried running a script to disable the server audit, but it runs forever...

 

Help???

Answer 3

ALTER SERVER AUDIT YourAuditName WITH (STATE = OFF);

---

velmurugan.s

Answer 4

Blue,

 

Try this:

- Execute the script to stop auditing

- Execute: SELECT * FROM sys.sysprocesses where blocked <> 0

Probably the spid you are using for disable will be blocked, verify the connection that is bloking and kill, if you can...

---

Fabrizzio A. Caputo
Certificações:
Oracle OCA 11g
MCITP SQL Server 2008 Implementation and Maintenance
MCITP SQL Server 2008 Developer
Blog Pessoal: www.fabrizziocaputo.wordpress.com
Blog Empresa: www.tripletech.com.br/blog
Twitter: @FabrizzioCaputo
Email: [e-mail]

Answer 5

This really doesn't answer the problem. Anyone have any more information. I get the same error and can only bounce the server to corret it.

---

JB