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 |
|
GenerationWithoutName
Starting Member
26 Posts |
 Posted - 2003-07-15 : 05:46:55
|
"Microsoft OLE DB Provider for SQL Server error '80004005' Transaction (Process ID 65) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction"WHAT'S WRONG WITH THAT ???? |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-07-15 : 06:00:43
|
| Read up on deadlocks in BOL. Here are some tips on minimizing deadlocking (from BOL):- Access objects in the same order.- Avoid user interaction in transactions.- Keep transactions short and in one batch.- Use a low isolation level.- Use bound connections. |
 |
|
|
|
|
|
Error Number!!!Help...!!!!