SQL Server Auditing (Audit)--How to create an audit

SQL Server Auditing (Audit)--How to create an audit

You can use SQL Server Management Studio or Transact-SQL to define auditing. After you create and enable auditing, the target receives the items.

You can use the Event Viewer utility in Windows to read Windows events. For a file destination, you can use the log file Viewer in SQL Server Management Studio or use the Fn_get_audit_file function to read the destination file.

The following is a general procedure for creating and using audits.

L Create audits and define targets.

L Create a server audit specification or database Audit specification that is mapped to an audit. Enable the audit specification.

L Enable auditing.

L Read audit events by using the Windows Event Viewer, log File Viewer, or the Fn_get_audit_file function.

This article is from the SQL Server deep dives blog, so be sure to keep this source http://ultrasql.blog.51cto.com/9591438/1595727

SQL Server Auditing (Audit)--How to create an audit