Venkataramana Mokkapati writes: > > select * from catalog with (UPDLOCK ROWLOCK) > where product = 'acs-101' > > gives me Table level lock (as can be seen through 'sp_lock' stored proc)! >
I doubt that this is a DBI issue. What do you get if you perform the same action through some other tool? Michael -- Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler [EMAIL PROTECTED] - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com
