How to force a deadlock
Eric
Date: 11/24/04
- Next message: CB: "Table Variable vs Temporary Table"
- Previous message: Alejandro Mesa: "Re: Who is logged in?"
- Next in thread: Uri Dimant: "Re: How to force a deadlock"
- Reply: Uri Dimant: "Re: How to force a deadlock"
- Reply: Toby Herring: "Re: How to force a deadlock"
- Reply: Alejandro Mesa: "RE: How to force a deadlock"
- Reply: Louis Davidson: "Re: How to force a deadlock"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 24 Nov 2004 08:36:51 -0600
Greetings,
We periodically get reports of record deadlocks, so we added Try...Catch
error handling in our ASP.NET application to fail gracefully. However, we
cannot test the error handling because we do not know how to force a
deadlock.
We have already tried this:
ASP.NET Application:
1. Go to screen with desired record
Query Analyzer:
2. Begin transaction
3. Update a record
ASP.NET Application:
4. Try to update that same record
Query Analyzer:
5. Commit transaction
When we do this, though, we just get a timeout expiration on step four.
Does anyone know how to do this?
Many thanks!
Eric
- Next message: CB: "Table Variable vs Temporary Table"
- Previous message: Alejandro Mesa: "Re: Who is logged in?"
- Next in thread: Uri Dimant: "Re: How to force a deadlock"
- Reply: Uri Dimant: "Re: How to force a deadlock"
- Reply: Toby Herring: "Re: How to force a deadlock"
- Reply: Alejandro Mesa: "RE: How to force a deadlock"
- Reply: Louis Davidson: "Re: How to force a deadlock"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
