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 |
|
Jothikannan
Starting Member
36 Posts |
 Posted - 2006-08-23 : 10:41:29
|
| Dear all,when i checked my deadlock log files , i found this line "TAB: 8:1097679604 [] CleanCnt:2 Mode: SIX Flags: 0x0"i couldnt find in which transaction this lock happened . any one can tell me in which circumstance sql server aquire "SIX" on the table level? And that table (1097679604) having 8 lakh records with 3 nc indexs.plz help me!!!Thanks Jothikannan |
|
|
|
|
|
need deadlock clarification