DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Transaction Process Dead Lock

  1. #1
    Eduardo Mireles Guest

    Transaction Process Dead Lock


    I would really appreciate if somebody could help me.

    I have been developing with Visual Basic 6.0 and Sql-Server 7.0 and I have
    launched some stored procedures that return an error very rare for me.
    This is the message error:

    Error '-2147467259 (80004005)' runtime error:

    Your transaction process id 41 was dead locked and there process has been
    dead locked
    - Return your transaction.

    this occurs when execute the any store procedure that only consults the database.

    But the most rare thing is that sometimes the store works and sometimes does
    not.

    Thanks in advance...
    Eduardo.

  2. #2
    Guest

    Re: Transaction Process Dead Lock

    > But the most rare thing is that sometimes the store works and sometimes
    does
    > not.


    (darin) Sounds like a typical deadlock scenario. Check out the articles on
    MSDN concerning deadlock. Generally, you can resolve these problems by

    1) narrowing down to only those sp's or code that exec's in a transaction

    2) looking at the order in file tables are queried and updated, then working
    through the combinations. It's a pain, but it's about the only way to do it.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center