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 |
|
shajimanjeri
Posting Yak Master
179 Posts |
 Posted - 2008-07-02 : 08:07:07
|
| I am getting this error when I open one of my table. This table have near to 100,000 records.The error is :[Microsoft][ODBC SQL server Driver] Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Return transaction.Anybody can give a solution to avoid this error on sql server2000 for this issue please.Shaji |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-02 : 08:23:14
|
| It will itself kill one process. You have to find what caused it.You can enable DBCC Traceon (1204,3605,-1) and see in error log. Remember: To reduce deadlocks:1)Normalize your database2)Access objects in same order3)Avoid high Isolation level. |
 |
|
|
shajimanjeri
Posting Yak Master
179 Posts |
Posted - 2008-07-02 : 08:31:21
|
| Thanks Sodeep for your kind replay,Here I just opened my table with Enterprise Manager (sql server 2000) then I have seen this error. Here Onething is that in this server (sql server 2000) I am running multiple tasks to insert, delete, update etc by using some exe applicatin. So here do u think that the reason will be with these tasks and exe files?Shaji |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-02 : 08:37:02
|
| Yes. you have to maintain order. Read what causes Deadlocks in Books online. |
|
|
|
|
|
|
Deadlock