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

    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
    Location
    Scotland
    Posts
    1,578
    Refer to this link for tips and tricks on using TRANSACTIONS.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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