Alternatively, you can set up auditing with T-SQL statements and also switch the audit off and on using the
ALTER SERVER AUDIT command by using the
WITH (STATE=ON) or
WITH (STATE=OFF) syntax, as shown in Listing 16.1.
/* Create the SQL Server Audit object, and send the results to the Windows Application event log. */USE master;goCREATE SERVER AUDIT NEW_SQL_Server_Audit TO APPLICATION_LOG WITH ( QUEUE_DELAY = 1000, ON_FAILURE = CONTINUE);GO/* Create the Database Audit Specification object using an Audit event */USE AdventureWorks2012;GOCREATE DATABASE AUDIT SPECIFICATION NEW_Database_Audit_SpecificationFOR SERVER AUDIT NEW_SQL_Server_Audit ...