Skip to Content
0
Apr 03, 2009 at 03:05 AM

How to find blocked number range objects?

88 Views

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 */

--