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.