select * from catalog with (UPDLOCK ROWLOCK) where product = 'acs-101'
gives me Table level lock (as can be seen through 'sp_lock' stored proc)! ActivePerl Build 629 DBI 1.14 W2K Any Clues? Thanks, MVRamana _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp