How to use the new function fn_get_sql()
By Bill Graziano
on 16 October 2003
| 0 Comments
| Tags: Administration
Narayana Vyas Kondreddi submitted "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 these new features, to inspect a given spid, and display the currently executing line/query." Follow the link to How to use the new function fn_get_sql()...