"ALTER DATABASE AUDIT SPECIFICATION DBAuditSpecName FOR SERVER AUDIT [ServerAuditName] WITH (STATE = OFF);" is producing: "Msg 33229, Level 16, State 1, Line 118 Changes to an audit specification must be done while the audit specification is disabled." #sqlhelp

I'm using SQL 2014

@MyHumbleSQLTips Your syntax is wrong. Try: ALTER DATABASE AUDIT SPECIFICATION DBAuditSpecName WITH (STATE=OFF) #sqlhelp