Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Triggers LOCKS transaction? (DEADLOCK problem)
Message
From
06/02/2004 09:52:56
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00874796
Message ID:
00874814
Views:
13
Hi Ricardo,

simple solution:
try and repeat the transaction rejected with deadlock error;
use SET DEADLOCK_PRIORITY to control which connection is rejected.
complex solution:
found the deadlock concurrency point on the TRIGGERS, and serialize it;
if you known, write the "Petri Net" of the triggers.
Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform