SQL Server 2005, List of Events Captured by the Default Trace

  • Article

Looking for a quick list of the events monitored/captured by SQL Server 2005's default trace? Here ya go:  

Database: Data File Auto Grow
Database: Data File Auto Shrink
Database: Database Mirroring State Change
Database: Log File Auto Grow
Database: Log File Auto Shrink
Errors and Warnings: ErrorLog
Errors and Warnings: Hash Warning
Errors and Warnings: Missing Column Statistics
Errors and Warnings: Missing Join Predicate
Errors and Warnings: Sort Warnings
Full text: FT:Crawl Aborted
Full text: FT:Crawl Started
Full text: FT:Crawl Stopped
Objects: Object:Altered
Objects: Object:Created
Objects: Object:Deleted
Security Audit: Audit Add DB User Event
Security Audit: Audit Add Login to Server Role Event
Security Audit: Audit Add Member to DB Role Event
Security Audit: Audit Add Role Event
Security Audit: Audit Addlogin Event
Security Audit: Audit Backup/Restore Event
Security Audit: Audit Change Audit Event
Security Audit: Audit Change Database Owner
Security Audit: Audit Database Scope GDR Event
Security Audit: Audit DBCC Event
Security Audit: Audit Login Change Property Event
Security Audit: Audit Login Failed
Security Audit: Audit Login GDR Event
Security Audit: Audit Schema Object GDR Event
Security Audit: Audit Schema Object Take Ownership Event
Security Audit: Audit Server Alter Trace Event
Security Audit: Audit Server Starts And Stops
Server: Server Memory Change