The auditing system provides the following enhancements:
Support of multiple audit tables. This capability allows you to archive and process audit data with no manual intervention and no loss of audit records.
A new, streamlined, user interface for the System Security Officer to control auditing. In the new interface, which replaces the current auditing interface, a single system procedure, sp_audit, provides the capability to set all auditing options.
The addition of events that can be audited, including:
Creation of objects
Binding and unbinding of rules, defaults, and messages
All actions by individual users
All actions performed with a particular role active
A set of server-wide, security-relevant events
