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 catalo
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 othe
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 downl
