SQLTeam.com Logo

Return to How to use the new function fn_get_sql()

How to use the new function fn_get_sql()

Written by Bill Graziano on 16 October 2003

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."