Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    22

    Unanswered: ODBC Error Code = 40001 (Serialization failure)

    We get this error constantly...

    24.121.0.118, Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322), ODBC Error Code = 40001 (Serialization failure) [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.


    Any ideas? Would setting the isolation level to Read Commited help?

  2. #2
    Join Date
    Sep 2004
    Posts
    22

    Thumbs up Found it!!

    Well, for those of you who care...

    I found out why I was getting these deadlocks all the time. Apparently we have a job that locks the table to do updates every 15 minutes. Nice eh?

    mitchell007, MCDBA

Posting Permissions

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