O'Reilly logo

SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond by Tom Carpenter

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

Auditing SQL Server Activity

While the Windows servers on which SQL Server 2008 run can implement auditing, SQL Server also supports internal auditing. The auditing can be accomplished using traditional methods, such as DDL triggers, or new methods in SQL Server 2008, such as audits and logon triggers. Notifications can also be configured so that SQL trace events or DDL triggers have a method for notifying administrative personnel. The following sections address these various methods and the steps required to implement them.

Using Audits

Those of you who implement and support SQL Server have been waiting a long time for the new audit architecture in SQL Server 2008. Now you finally have the ability to set up automatic auditing without the requirement ...

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