Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Question Unanswered: Detection of error in SP

    Does anyone know if in a stored procedure the code can determine if a deadlock has occurred?

    Thanks
    Jim

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Check error 1205. be carefull in a sp, because the deadlock victim is loosing its connection
    Last edited by fadace; 03-01-04 at 09:24.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •