Results 1 to 2 of 2

Thread: lock timeouts

  1. #1
    Join Date
    May 2002

    Unanswered: lock timeouts

    I have a procedure running which is locking a table. I want to execute another one, knowing fullwell it wants to use the locked table. Can I go home and expect the 2nd proc. to run when the table becomes unlocked or will it time out while waiting and send an error.


  2. #2
    Join Date
    Feb 2002
    The procedure will wait indefinitely unless there is a deadlock or the LOCK_TIMEOUT setting has a value other than -1.

Posting Permissions

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