Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Posts
    1

    Question Unanswered: Dead locks in SQL SErver 2000

    May I know the best solution for minimising dead locks.

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    do you have a specific problem or asking for theory?
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    can you privide some information about what's going on? What type of environment, what are users doing when the deadlock occures, is this one table or multipule tables involved?
    Paul Young
    (Knowledge is power! Get some!)

  4. #4
    Join Date
    Apr 2003
    Location
    SC, USA
    Posts
    51
    I recently stumbled across a pretty good synopsis of deadlocking in SQL Server over at the PASS website (Professional Association for SQL Server) that's in their public-access area. Here's the URL:

    http://www.sqlpass.org/resources/ses.../S231_S348.ppt

Posting Permissions

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