Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003

    Red face Unanswered: Store Procedure, Transaction and Lock

    When I call a Store Procedure without Transaction it returns normally after about 20 mins. But when I call the same Store Procedure with Transaction, it dont return even after few hours later!!!
    I call sp_lock and see a lots of locks there when I call the same Store Procedure with Transaction.

    Any one met this kind of problems before?? Who can give me a reason??
    And how to avoid this problem??

    Need your advice, mates!
    Attached Thumbnails Attached Thumbnails confused.gif  

  2. #2
    Join Date
    Aug 2002
    Refer to this link for tips and tricks on using TRANSACTIONS.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

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