hi,
is there a way to designate a certain SP as the winner of all deadlocks? I
have one SP that processes all incoming transactions and would really like
it to win any deadlock situation.
tia
by Alex B » Fri, 22 Sep 2000 04:00:00
is there a way to designate a certain SP as the winner of all deadlocks? I
have one SP that processes all incoming transactions and would really like
it to win any deadlock situation.
tia
by Keith Kratochvi » Fri, 22 Sep 2000 04:00:00
NOPE!
SQL Server will kill and rollback the "easier" transaction.
Keith
Quote:> hi,
> is there a way to designate a certain SP as the winner of all deadlocks?
I
> have one SP that processes all incoming transactions and would really like
> it to win any deadlock situation.
> tia
by Alex B » Fri, 22 Sep 2000 04:00:00
thanks for the reply! that's definitely a bummer, since in this case, i
really need it to finish the "easy" transaction ...
> Keith
> > hi,
> > is there a way to designate a certain SP as the winner of all deadlocks?
> I
> > have one SP that processes all incoming transactions and would really
like
> > it to win any deadlock situation.
> > tia
by Erland Sommarsk » Fri, 22 Sep 2000 04:00:00
--
by Brad Irb » Fri, 22 Sep 2000 04:00:00
It sets priority by session, not SP, but it may help if you have a specific
process that you want to win and another specific one that is usually
theother half of the deadlock and you want it to lose.
Brad Irby
VP Software Development
CRSD Inc.
www.crsdinc.com
Quote:> hi,
> is there a way to designate a certain SP as the winner of all deadlocks?
I
> have one SP that processes all incoming transactions and would really like
> it to win any deadlock situation.
> tia
1. row level locking and dead-lock prevention
2. Q: How to browse large DB table with small JTable?
5. How do I narrow down search?
6. Dead Locks?
7. IM006: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
10. Record Dead Lock
11. SQL Server 2000 JDBC driver causing dead lock
12. Dead lock