How to find blocked number range objects?

[former_member211576]

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

--

[gudmundur_karlsson]

Hi Dennis,

the SQL Profiler should show it to you.

You should see either

sp_execute <n>,V1,V2,...

Where Vn are the @P parameter values.

Or if it's sp_executesql then you should see the statement text, followed by the @P argument declarations, followed by the Vn values.

sp_execute should be adjacent to the text you show (either before or after). You should be able to figure it out from the number of parameters.

Gudmundur

[former_member211576]

use MSSQL DMV