Administering SQL Server
Objects Event Classes
The following table describes the Objects event classes in the Objects event category.
| Event class | Description |
|---|---|
| Auto Stats | Indicates when the automatic creation and updating of statistics has occurred. |
| Object:Closed | Indicates when an open object has been closed (for example, such as at the end of a SELECT, INSERT, or DELETE statement). |
| Object:Created | Object has been created (for example, for CREATE INDEX, CREATE TABLE, and CREATE DATABASE statements). |
| Object:Deleted | Object has been deleted (for example, for DROP INDEX and DROP TABLE statements). |
| Object:Opened | Indicates when an object has been accessed (for example, for SELECT, INSERT, or DELETE statements). |
The Object:Created and Object:Deleted event classes can be used to determine whether many ad hoc objects are being created or deleted (for example, by ODBC applications that often create temporary stored procedures). By monitoring the DBUserName and NT User Name default data columns in addition to the Objects event classes, you can determine the name of the user who is creating, deleting, or accessing objects. This can be used to determine whether your security policies are correctly implemented, for example, to confirm that users who are not allowed to create or delete objects are not doing so.