dbcc inputbuffer doesn't providefull stmt?

• Amu

  SSCommitted

  Points: 1691

  More actions

  November 15, 2007 at 6:25 am

  #377073

  How can I capture the full sql stmt if I have spid that is blocking? I use dbcc inputbuffer but getting truncated after 255 characters. neone with ne script or way to get full stmt? thanks!

• Amu

  SSCommitted

  Points: 1691

  More actions

  November 15, 2007 at 12:42 pm

  #751622

  Found it but doesn't work all time. as long as its in cache.

  DECLARE @Handle binary(20)

  SELECT @Handle = sql_handle

  FROM master.dbo.sysprocesses

  WHERE spid = spid#

  SELECT *

  FROM ::fn_get_sql(@Handle)

• sqldba.mohan

  Grasshopper

  Points: 13

  More actions

  January 6, 2011 at 4:09 pm

  #1270363

  Try capturing the results of dbcc inputbuffer to text