I am not too familiar with SQL 6.5, so the following information only applies to SQL 7 and SQL 2000. It might work for SQL 6.5. I just don't have...

shoayb,

I am glad you found this article helpful. In fact, you could easily edit that stored procedure and use it to trace deadlocks, do performence tuning and lots of other...

Deema,

Thanks for reading my article.

It's normal for the file size to be 0 when the trace just got started. SQL Trace does not write to this file right away. For...

Hi,

There is one mistake in the beginning of the scripts. Instead of DROP PROCEDURE usp_Login_Audit_Trace, the article says DROP PROCEDURE dbo.spRoleMembers. My apologies and much thanks to reader William...

Thanks again.

I incorrectly assumed that @p1...@pn are user-defined variables and that apprently caused some confusion. My apologies.

Brian is right. My earlier trace only traced the TSQL-SQL:StmtStarting. So the only results...

Thanks guys.

I'm not interested in tracking the values of SQL server pre-defined variables, like @@ROWCOUNT or @@SPID (althrough it would be great to be able to track those as well)....