Re: How to force a deadlock

Eric
Date: 11/24/04


Date: Wed, 24 Nov 2004 08:38:45 -0600

Sorry! Wrong newsgroup!

<Eric> wrote in message news:uUyJcLj0EHA.1192@tk2msftngp13.phx.gbl...
> 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
>
>



Relevant Pages

  • How to force a deadlock
    ... We periodically get reports of record deadlocks, ... error handling in our ASP.NET application to fail gracefully. ... Query Analyzer: ... Commit transaction ...
    (microsoft.public.windows.server.security)
  • How to force a deadlock
    ... We periodically get reports of record deadlocks, ... error handling in our ASP.NET application to fail gracefully. ... Query Analyzer: ... Commit transaction ...
    (microsoft.public.sqlserver.programming)