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 |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2004-10-14 : 13:34:51
|
| Iam facing the issue of locking.when I check the management in the enterprise management i see the process_id as -2 in certain database(locks/objects).How should I over come this.Killing the process from lock_info table or canI do something in the queries which won't lock the tables |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-14 : 13:44:59
|
| Locking is normal. Are you seeing blocking problems or deadlocks or anything else besides locking?Tara |
 |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-10-14 : 15:06:38
|
| No just locking..so what currently we do is scheduled a job to run so that it kills the process whenever there is a lock |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-14 : 15:47:58
|
| You shouldn't be doing that. Locking is normal behavior. I would suggest reading up on locks in BOL for more information.Tara |
|
|
|
|
|
|
issue with locking tables