Blog - Single Post

 SELECT d.name ,
        CONVERT (SMALLINT, req_spid) AS spid
 FROM   master.dbo.syslockinfo l ,
        master.dbo.spt_values v ,
        master.dbo.spt_values x ,
        master.dbo.spt_values u ,
        master.dbo.sysdatabases d
 WHERE  l.rsc_type = v.number
        AND v.type = 'LR'
        AND l.req_status = x.number
        AND x.type = 'LS'
        AND l.req_mode + 1 = u.number
        AND u.type = 'L'
        AND l.rsc_dbid = d.dbid
        AND rsc_dbid = ( SELECT TOP 1
                                dbid
                         FROM   master..sysdatabases
                         WHERE  name LIKE 'mydbName'
                       );