Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2005-06-06 : 13:02:52
|
| I have some locks on my SQL server and did a sp_lock and got the following results. How do I solve this, as I have about eight of them on one server all saying the same thing.spid dbid ObjId IndId Type Resource Mode Status ------ ------ ----------- ------ ---- ---------------- -------- ------ 51 4 0 0 DB S GRANTAll help appreciated. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
NoNulls
Starting Member
14 Posts |
Posted - 2005-06-06 : 15:05:07
|
| http://www.sommarskog.se/sqlutil/aba_lockinfo.htmlThis is one of my favorite for lock issues. Try his aba_lockinfo procedure....good stuff here |
 |
|
|
|
|
|
solving locks using sp_lock