Hi experts,
We have blocked locks issue on NRIV. I need to find affected number range objects. In ST04->Lock hostiry->Dbcc inputbuffer does not show complete SQL statement, so I can't find object name here. I use SQL Server profiler but only find parametered SQL Statement like below. I need to know the the value of @P6 & @P7. What should I do?
--
UPDATE "NRIV" SET "FROMNUMBER" = @P1 ,"TONUMBER" = @P2 ,"NRLEVEL" = @P3 ,"EXTERNIND" = @P4 WHERE "CLIENT" = @P5 AND "OBJECT" = @P6 AND "SUBOBJECT" = @P7 AND "NRRANGENR" = @P8 AND "TOYEAR" = @P9
/* R3:KRN:0 T:NRIV */
--