var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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.