Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deadlock revisited
Message
 
 
À
16/02/2009 20:46:39
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2005
Application:
Web
Divers
Thread ID:
01381607
Message ID:
01382307
Vues:
33
>>Yes as long as update of both tables happen in the same transaction.
>
>If this is in reference to updating two tables within one update command, I do not have that. Each update is only applied to one table at a time. But, within the same hit, doing an update in the Monitor table, will by the same trigger an update in the Member table as this is always done at the end of the hit. So, if I understand correctly, the cause of this deadlock issue would be caused by something else.

If you're using automatic transaction than yes. If you're using manual transaction than I wouldn't know w/o seeing what is included in a transaction.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform