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.
/* 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 ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.