database table structure and data can sometimes be unintentional or malicious, or need to track the recent data structure change records, in the past must be through the log query, SQL Server2008 began to provide auditing (Audit) function, SQL2012 upgrade, use it can realize the database change record
Here's how to create a audit:
First step: Open the Database Manager security = "Audit (Audit)
Right-click New audit
New when everything is default, select the log file storage path can be
Click "Confirm" to create a successful
Note: When created, the default is not turned on and right-click.
Step Two: Create an audit rule
If you need to audit a database requires a new specification in the database = "Security =" Database Audit specification
As shown here, a select monitoring and structural change monitoring of the table th is created, and the common monitoring parameters
Step three: View the audit log
The contents of database modifications can be clearly seen through the log
Attention:
Schema_object_change_group: can monitor table structure changes
SQLSERVER2012 Audit (Audit) function