Home Forums SQL Server 7,2000 T-SQL Mimic Current Activity behaviour RE: Mimic Current Activity behaviour
Ian Scarlett
SSC-Insane
Points: 23197
More actions
June 5, 2003 at 5:13 am
#459888
DBCC INPUTBUFFER(spid)
This only gets the first 255 characters of the command.
SP3 introduced the fn_get_sql function (see the updated SP3 BOL for details), which returns the information in a text column.