[dba-SQLServer] syslock help

Jean-Paul natola jnatola at hotmail.com
Thu Aug 4 15:53:56 CDT 2011


Hi all,
 
 
We have a user that got "locked"  in some process or transaction or  table, excuse the language here,  the former version of the program had a syslocks utility to release anything in that type of situation,   it turns out that utlity was removed and the only thing i could find to point me in the right direction was a querey i found online,
 
SELECT * FROM master.dbo.syslockinfo 
 
here is what it output  but i can really make heads or tails
I know its not a lot to go on, but any pointers thoughts would be appreciated
 
 
column headers are 
rsc_bin,rsc_valblk,rsc_dbid,rsc_indid,rsc_objid,rsc_type,_rsc_flag,req_mode,req_statu,req_refcnt,req_cryrefecnt,req_lifetime,req_spid,req_ecid,req_ownertype,req_transactionid,req_transactionUOW
 
 
 0x00000000000000000000000005000200 0x00000000000000000000000000000000 5 0 0 2 0 3 1 1 0 0 53 0 4 0 00000000-0000-0000-0000-000000000000
                                 0x00000000000000000000000005000200 0x00000000000000000000000000000000 5 0 0 2 0 3 1 1 0 0 51 0 4 0 00000000-0000-0000-0000-000000000000
                                 0x00000000000000000000000007000200 0x00000000000000000000000000000000 7 0 0 2 0 3 1 1 0 0 56 0 4 0 00000000-0000-0000-0000-000000000000
                                 0x00000000000000000000000007000200 0x00000000000000000000000000000000 7 0 0 2 0 3 1 1 0 0 54 0 4 0 00000000-0000-0000-0000-000000000000
                                 0x00000000000000000000000007000200 0x00000000000000000000000000000000 7 0 0 2 0 3 1 1 0 0 52 0 4 0 00000000-0000-0000-0000-000000000000

 
 
 
 		 	   		  


More information about the dba-SQLServer mailing list