Home Forums SQL Server 7,2000 T-SQL Mimic Current Activity behaviour RE: Mimic Current Activity behaviour

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