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 |
|
imrul
Starting Member
36 Posts |
 Posted - 2008-05-21 : 10:49:09
|
| I got Transaction Deadlocked message as two or more process trying to update the same table at a time. Is there any way to see from log which process were trying to update/Insert a table? |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-05-21 : 11:50:52
|
| No, it'll simply tell you a process has been chosen as a deadlock victim. You can fire up profiler to watch what's going on and get more detail.Terry |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-21 : 14:49:59
|
| you can enable traceflag (-T1204) to get info about deadlock and locks and -T3605 to get in error log. |
|
|
|
imrul
Starting Member
36 Posts |
Posted - 2008-05-22 : 01:30:44
|
| Thanks everybody. I am trying with your suggestions |
|
|
|
|
|
|
Transaction was deadlocked