USE [master] GO CREATE SERVER AUDIT [TestDB-DBAudit] TO FILE ( FILEPATH = N'C:\Audits\SQLAudits\' ,MAXSIZE = 10 MB ,MAX_ROLLOVER_FILES = 2147483647 ,RESERVE_DISK_SPACE = ON ) WITH (QUEUE_DELAY = 10000, ON_FAILURE = CONTINUE) WHERE ([succeeded]=(1) OR [succeeded]=(0)) ALTER SERVER AUDIT [TestDB-DBAudit] WITH (STATE = ON) GO