How to use the new diagnostic system function fn_get_sql() and the 3 new columns of sysprocesses?

By Vyas Kondreddi – This article shows you how to use the new function fn_get_sql() and the 3 new columns of master.dbo.sysprocesses. These changes were introduced in SQL Server 2000 SP3/SP3A. In this article, you will find a general purpose stored procedure called ShowCodeLine. It makes use of thes

Read More - Register for Free Membership