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 |
|
vinothonline
Starting Member
4 Posts |
 Posted - 2007-08-24 : 08:17:52
|
| I get the below error in vb6.0 application with back end sql server 2000.When concurrent users use the application (nearly 7 users) the application slows down and throws the below error. The error occurs in the point where i have called an sp ,which contains a insert query ."Transaction(Process Id 70) was deadlocked with on {lock} resources with another process and has been chosen as the deadlock victim . Reerun the ttransaction . 0 "Plz reply meThanks in advance |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-24 : 23:40:58
|
| Turn on trace flag 1204 and 1206, sql will log details in sql server log. |
 |
|
|
|
|
|
Help needed in Deadlock error