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