The default SQL Server trace from SQL Server 2005 onwards is a background trace that runs continuously and records event information that can be useful in troubleshooting problems. Though the list is long, the following are captured by default trace..

• Data file auto grow
• Data file auto shrink
• Database mirroring status change
• Logfile auto grow
• Logfile auto shrink
• Error log
• Missing Column Statistics
• Missing Join Predicate
• Object Altered
• Object Created
• Object Deleted
• Server Memory Change

Apart from these many other SQL Server Security Auditing events are also captured like Add DB user event, DBCC event, Login Failed, Backup/Restore event, Server Starts and Stops and many more.