Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Database Engine
Secure Operation

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
SQL Server 2008 Books Online (June 2009)
Auditing (Database Engine)

SQL Server provides several features that you can use for auditing activities and changes on your SQL Server system.

These features enable administrators to implement a defense-in-depth strategy that they can tailor to meet the specific security risks of their environment.

This topic provides links to help you locate the information that you need for using auditing on the SQL Server Database Engine.

Understanding SQL Server Audit

Provides conceptual information about the SQL Server Audit feature.

SQL Server Audit How-to Topics

Provides how-to information about the SQL Server Audit Feature

Server Properties (Security Page)

Explains how to turn on login auditing for SQL Server. The audit records are stored in the Windows application log.

c2 audit mode Option

Explains the C2 security compliance auditing mode in SQL Server.

Security Audit Event Category (SQL Server Profiler)

Explains the audit events you can use in SQL Server Profiler. For more information, see Using SQL Server Profiler.

Introducing SQL Trace

Explains how SQL Trace can be used from within your own applications to create traces manually, instead of using SQL Server Profiler.

DDL Triggers

Explains how you can use Data Definition Language (DDL) triggers to track changes to your databases.

Microsoft TechNet: SQL Server TechCenter: SQL Server 2005 Security and Protection

Provides up-to-date information about SQL Server security.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker