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 |
|
dev2dev
Starting Member
48 Posts |
 Posted - 2008-04-14 : 04:10:21
|
| Hi,I am adding deadlock handling code by putting while loop block where the loop executes aslong as we get error 1205 (which is now warning).I am just wondering if deadlock can happen for below actions.ALTER DATABASE, when CREATEing/DROPing FILE/FILEGROUPALTER TABLE, when trying to SWITCH the PARTITION of a TABLEJust thinking it is not worth handling if this won't happen for above casescomments...Thanks-D |
|
|
|
|
|
deadlock scenarios (can deadlock happen while...)