Page History
...
| Event class | SQL Server version | Description |
|---|---|---|
| Audit Add Login | SQL Server 2000 only | Records when a SQL Server login is added to or dropped from a registered SQL Server instance In SQL Server 2005 and later, this event class is Audit Server Principal Management |
| Audit Add Login To Server Role | SQL Server 2000 and later | Records when a login is added to or removed from a server role |
| Audit Change Database Owner | SQL Server 2005 and later | Records when the ALTER AUTHORIZATION statement is used to specify a different database owner |
| Audit Database Management | SQL Server 2005 | Records all DROP, ALTER, and CREATE operations on a database |
| Audit Login | SQL Server 2000 and later | Records all successful logins on the registered SQL Server instance |
| Audit Logouts | SQL Server 2000 and later | Records all logouts on the registered SQL Server instance |
| Audit Login Change Password | SQL Server 2000 and later | Records all password changes for logins on the registered SQL Server instance |
| Audit Login Change Properties | SQL Server 2000 and later | Records changes in default database and language properties for all logins on the registered SQL Server instance |
| Audit Login Failed | SQL Server 2000 and later | Records all logins that failed an access check on the registered SQL Server instance |
| Audit Login GDR | SQL Server 2000 only | Records all GRANT, REVOKE, or DENY actions on Windows 2000 user account login rights In SQL Server 2005 and later, this event class is Audit Server Principal Management |
| Audit Object Derived Permission | SQL Server 2000 only | Records CREATE and DROP commands executed on a server object, such as CREATE DATABASE or DROP DATABASE In SQL Server 2005 and later, this event class is Audit Database Management |
| Audit Server Alter Trace | SQL Server 2005 and later | Records when an ALTER TRACE permission check is executed for a T-SQL statement that creates, configures, or filters a SQL trace |
| Audit Server Object GDR | SQL Server 2005 and later | Records all GRANT, REVOKE, or DENY actions on permissions for executing T-SQL statements on the audited schema object, such as a table or function |
| Audit Server Object Management | SQL Server 2005 and later | Records all DROP, ALTER, and CREATE operations on server objects |
| Audit Server Object Take Ownership | SQL Server 2005 and later | Records when ownership of an audited server object changes |
| Audit Server Operation | SQL Server 2005 and later | Records all security operations executed on the audited server |
| Audit Server Principal Impersonation | SQL Server 2005 and later | Records when impersonation is used to access or act on a server object |
| Audit Server Principal Management | SQL Server 2005 and later | Records all DROP, ALTER, and CREATE operations on server principals |
| Audit Server Scope GDR | SQL Server 2005 and later | Records all GRANT, REVOKE, or DENY actions on permissions for executing T-SQL statements that change the server scope, such as creating a login |
| Audit Statement Permission | SQL Server 2000 only | Records when a user is authorized to execute a T-SQL statement on the registered SQL Server instance In SQL Server 2005 and later, this event class is Audit Database Management |
...