O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required