Microsoft® SQL Server 2012 Unleashed

Setting Up Auditing via T-SQL

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.

LISTING 16.1 Setting Up Auditing with T-SQL

Click here to view code image

/* 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 ...