(─━┘_└━─)/ 머리만1톤(Head1Ton)

create proc dbo.sp_block (@spid bigint=NULL)

as

-- This stored procedure is provided "AS IS" with no warranties, and confers no rights.

-- Use of included script samples are subject to the terms

-- specified at http://www.microsoft.com/info/cpyright.htm

select t1.resource_type

           , 'database'=db_name(resource_database_id)

           , 'blk object' =isnull(object_name(t1.resource_associated_entity_id) ,t1.resource_associated_entity_id)

           , t1.request_mode

           , t1.request_session_id   -- spid         

           , t2.blocking_session_id  -- spid         

from sys.dm_tran_locks as t1,

           sys.dm_os_waiting_tasks as t2

where t1.lock_owner_address = t2.resource_address

and t1.request_session_id = isnull(@spid,t1.request_session_id)

GO