By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,691 Members | 1,997 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,691 IT Pros & Developers. It's quick & easy.

identifying rows locked in row level locking

P: n/a
> I understand that ObjID of LOCKtag recognizes each individual row locked
a row level lock. BUt i have noticed that if i lock 2 different rows of the
same table they have the same blkno. is this deduction ok?

If they happen to be stored in the same block, they'd have the same blkno
then how would we recognize each individual row locked?

__________________________________________________ _______________
Get MSN 8 and enjoy automatic e-mail virus protection.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******

Nov 11 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.