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 |
|
jaroot
Starting Member
46 Posts |
 Posted - 2005-11-18 : 11:28:16
|
| I can't open a table that has 5 records. Is there any kill processes that can unlock the table for me? |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-11-20 : 22:06:42
|
| and before killing the spid, be sure that there's no major processing that needs to be rolled back if you kill the process...like a couple of millions/thousands of inserts, deletes or updatesHTH--------------------keeping it simple... |
 |
|
|
|
|
|
SQL table locked up. How do I unlock it?