Is the product column indexed? Without an index the SQL server may be forced to
According to msdn UPDLOCK "hold(s) locks until the end of the statement or transaction". Did you complete the transaction? Michael Peppler wrote: > > 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
