One of the more essential SQL Server tools is its trace utility. With it you can view the activity occurring against a SQL Server for diagnostic, informational, and other purposes. Because it lets you ...

[!INCLUDE SQL Server] Although running SQL Trace incurs a performance cost because it uses system resources to gather data, you can do many things to minimize it. To minimize the performance cost ...

[!INCLUDE SQL Server] The process of tracing with SQL Trace varies depending on whether you create and run your trace by using Microsoft [!INCLUDEssSqlProfiler] or by using system stored procedures.

In the past, the question of how to perform auditing under SQL Server has had a simple answer: Do it yourself. But now, SQL Server 2000 has eased the burden of auditing by introducing an extensive and ...