SQL Trace — the server-side tracing utility — manages an event queue whose purpose is to record events produced by various components of SQL Server’s query and relational engines.

SQL Trace is the heart of SQL Server 2000’s auditing capabilities. In fact, Microsoft resurrected SQL Trace, which had been downplayed in SQL Server 7.0, specifically to facilitate auditing.