Audit SQL Server Databases

摘要

Developera and DBAs using Ml-crosoft SQL Server always look for ways to log events of Interest to them as they occur on the server. SQL Server '08 fulfills this need with the Introduction of audits, where we no longer have to write triggers and hooks to trap events of interest.rnThe Audit feature Is however, available only In the Enterprise Edn. We take you through the steps tornstart auditing your server.rnFirst create an audit object. This essentially defines a destination to which SQL Server will record Information about Interesting events that occur.