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 |
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
 Posted - 2005-03-11 : 21:58:11
|
| is there a way we can control deadlocks without changing client's source code like in SQL(stored proc) instead?a problem arises when two client's pick different records and almost simultenously update the recordset (different). when this happens one of the client flags a deadlock error mess.we are using SQL 2000 server on different client languages.Want Philippines to become 1st World COuntry? Go for World War 3... |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-03-11 : 22:44:47
|
| That depends on what's causing the deadlocks. If the client's source code is holding locks while the user interacts with the data then you probably won't be able to do much. Have you read about deadlocks in BOL, particularly the topic "avoiding deadlocks"?Be One with the OptimizerTG |
 |
|
|
|
|
|
deadlock transactions