John,

Here are the results of DBCC INPUTBUFFER.

Thanks,

Karen

**Blocking spid 507**

dbcc inputbuffer(507)

EventTypeParametersEventInfo

Language Event0select db_name()

**Suspended spid 149 **

dbcc inputbuffer(149)

EventTypeParametersEventInfo

Language Event0(@P1 nvarchar(1),@P2 nvarchar(12),@P3 nvarchar(8),@P4 nvarchar(6),@P5 nvarchar(8),@P6 nvarchar(6),@P7 nvarchar(12),@P8 nvarchar(12),@P9 nvarchar(40),@P10 nvarchar(45),@P11 nvarchar(3),@P12 nvarchar(12))UPDATE "SWT_LOGCAT" SET "HANDLETYPE" = @P1 ,"CREATED_BY" = @P2 ,"CREATED_ON" = @P3 ,"CREATED_AT" = @P4 ,"CHANGED_ON" = @P5 ,"CHANGED_AT" = @P6 ,"RETAIN_BY" = @P7 ,"WI_ID" = @P8 ,"DESCRIPTIO" = @P9 ,"OBJECT" = @P10 WHERE "MANDT" = @P11 AND "HANDLE" = @P12 /* R3:RTAB:0 T:SWT_LOGCAT */

From SP_WHO2, I see that the suspended spid (149) is doing an update. The blocking spid (507) is AWAITING COMMAND.