Begin Transaction
Select * From SP6 With (HoldLock) Where Id= 1 

CREATE PROCEDURE Blk_RowTable
	@SPId Int,@TableName VarChar( 20 ),@RowId Numeric( 12 ),@Cnt_blocked Int Out
AS
Begin

Declare @SrtExec VarChar( 200 ),@ObjId Numeric( 12 ),@IndId Numeric( 12 ),@Resource Char( 16 )

Begin Transaction
Select @SrtExec='Declare @id Numeric(12) Select @id=id From '+@TableName+' With (HoldLock)'+' Where Id='+Str(@RowId)
exec (@SrtExec)
select 	
	@ObjId=rsc_objid,
	@IndId=rsc_indid,
	@Resource=substring (rsc_text,  1 ,  16 )
from 	master.dbo.syslockinfo,
	master.dbo.spt_values v
where   master.dbo.syslockinfo.rsc_type = v.number
	and v.type = 'LR'
	and substring (v.name,  1 ,  4 )='KEY '
	and convert (smallint, req_spid)=@SPId

 --Select 	@ObjId objid,
 
 --	@IndId indid,
 
 --	@Resource Resource,
 
 --	@SPId SPId
 

select @cnt_blocked=count(req_spid) 
from 	master.dbo.syslockinfo,
	master.dbo.spt_values v
where   master.dbo.syslockinfo.rsc_type = v.number
	and v.type = 'LR'
	and @ObjId=rsc_objid
	and @IndId=rsc_indid
	and 'KEY '=substring (v.name,  1 ,  4 )
	and @Resource=substring (rsc_text,  1 ,  16 )
	and convert (smallint, req_spid)<>@SPId
RollBack Transaction
End
GO

Begin Transaction
Select * From SP6 With (HoldLock) Where Id= 1