Re: MSSQL Row levels locks from DBI

2001-10-03 Thread Simon Oliver 

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

MSSQL Row levels locks from DBI

2001-10-02 Thread Venkataramana Mokkapati 


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

Re: MSSQL Row levels locks from DBI

2001-10-02 Thread Michael Peppler 

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