Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Posts
    9

    Lightbulb Unanswered: Locking Concepts :

    Locking Concepts :

    If Transaction1 is holding a 'Update Lock' then Transaction2 can acquire a 'Shared Lock'(on the same resource, ofcourse !!). I hope this statement is correct.

    Now can Transaction1 acquire a Exclusive lock on the particular resource with the Transaction2 is still holding on to its 'Shared Lock'.

    Any Ideas !!! I need this info for designing updates to the database running under MTS Transactions.


    Regards,

    Ashutosh

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Nope - exclusive means exclusive.

    You can test this easily enough (and you should get into the habit of doing so) by running in two windows of query analyser.

Posting Permissions

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