For non-serialized does key lock lock more than one row?

For Sql 2000, for isolation levels not serialized, can a key lock
(especially created by an inserted row), involving a nonprimary key index
end up locking more than one row?

Thanks,

Randy Neall

"Randolph Neall" < randolphneall@veraci
tycomputing.com> wrote in message
news:#GWEwT8EHHA.3780@TK2MSFTNGP02.phx.gbl...
> For Sql 2000, for isolation levels not serialized, can a key lock
> (especially created by an inserted row), involving a nonprimary key index
> end up locking more than one row?
>

Since each key in a non-unique index may relate to multiple rows, a key lock
on a non-unique index typically impacts multiple rows, since   The rows
themselves are not locked, but the key lock will be inconsistent with any
other transaction reading or locking that index key.  So it may well block
other operations on other rows that share that index key.

David

Thanks, David.
Randy


"David Browne" <davidbaxterbrowne no potted meat@hotmail.com> wrote in
message news:OsJQ508EHHA.3780@TK2MSFTNGP02.phx.gbl...
>
>
> "Randolph Neall" < randolphneall@veraci
tycomputing.com> wrote in message
> news:#GWEwT8EHHA.3780@TK2MSFTNGP02.phx.gbl... 
 index
 
>
> Since each key in a non-unique index may relate to multiple rows, a key
lock
> on a non-unique index typically impacts multiple rows, since   The rows
> themselves are not locked, but the key lock will be inconsistent with any
> other transaction reading or locking that index key.  So it may well block
> other operations on other rows that share that index key.
>
> David
>