Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Location
    N Delhi
    Posts
    11

    Unanswered: Can I place Lock for some time in a Transaction

    Dear all,

    I have a transaction performing some oeprations. Can I Lock (UPDLOCK) some table for some time in transaction and then release the lock. Basically if i place the lock on table it remains there for whole transaction duration. What to do if I want to release it explicitly in transaction?

    Thanks in advance,
    Avneesh

  2. #2
    Join Date
    May 2003
    Location
    Athens Greece
    Posts
    13
    I do not understand,
    can you please be more specific?

  3. #3
    Join Date
    Mar 2003
    Location
    N Delhi
    Posts
    11
    Lets take an example to be more specific about problem
    -----------------------------------------------------------------
    Begin tran
    Lock mytab with UPDLOCK
    ....Do Some operation....
    Release lock on mytab
    ....Do some operation.....
    Commit tran
    -----------------------------------------------------------------

    Is this possible?

    If you have some idea then most welcome.

    Thanks in advance,
    Avneesh

Posting Permissions

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