How to enable SQL Server tracing

Posted: 23.9.2008 15.22.56 (EET/GMT+2)

If you are developing applications for Microsoft SQL Server, or need to maintain such a server, you might want an utility to monitor those SQL statements that your (own) applications execute against the database server.

Luckily, SQL Server supports an utility (in SQL Server 2005, anyway) called SQL Profiler, which supports traces. When you launch this utility from the Start menu, you can go to File/New Trace, and then hit OK. Once you do this, the screen will start to display information about all SQL statements executed or run against the database server in question. Yes, it's that easy!

Microsoft's KB article 224587 gives additional details. Keywords: How to enable tracing in Microsoft SQL Server, HOWTO, tracing, monitoring SQL statements.