Select * From

(

--©Drkb v.3(2007): <a href="http://www.drkb.ru

" title="www.drkb.ru

">www.drkb.ru

</a>    select    convert (smallint, req_spid) As spid,

        Db_Name(rsc_dbid) As dbName,

        Object_Name(rsc_objid) As ObjId,

        rsc_indid As IndId,

        Case substring (v.name, 1, 4)

            when 'FIL' then 'File'

            when 'DB' then 'Database'

            when 'IDX' then 'Index'

            when 'PAG' then 'Page'

            when 'KEY' then 'Key'

            when 'TAB' then 'Table'

            when 'EXT' then 'Extent'

            when 'RID' then 'Row'

            else v.name

        End As LockType,

        substring (rsc_text, 1, 16) as Resource,

        Case substring (u.name, 1, 8)

            When 'S' then 'Shared'

            When 'U' then 'Update'

            When 'X' then 'Exclusive'

            When 'I' then 'Intent'

            When 'IS' then 'Intent Shared'

            When 'IX' then 'Intent Exclusive'

            When 'IU' then 'Intent Update'

            When 'SIX' then 'shared with intent exclusive'

            When 'BU' then 'Bulk Update'

            else u.name

        End As LockMode,

        substring (x.name, 1, 5) As Status

    from    master.dbo.syslockinfo,

        master.dbo.spt_values v,

        master.dbo.spt_values x,

        master.dbo.spt_values u

    where  master.dbo.syslockinfo.rsc_type = v.number

            and v.type = 'LR'

            and master.dbo.syslockinfo.req_status = x.number

            and x.type = 'LS'

            and master.dbo.syslockinfo.req_mode + 1 = u.number

            and u.type = 'L'

) as t

Where dbName=Db_Name() and ObjId is not NULL

Order By ObjId, LockMode