Bol error

Anyone know if this has been resolved? Not hugely important, more
amusing. Thought I was patched up.

sp_lock
Reports information about locks.

Syntax
sp_lock [[@.spid1 =] 'spid1'] [,[@.spid2 =] 'spid2']

Arguments
[@.spid1 =] 'spid1'

Is the Microsoft SQL Server process ID number from
master.dbo.sysprocesses. spid1 is int, with a default of NULL. Execute
sp_who to obtain process information about the lock. If spid1 is not
specified, information about all locks is displayed.

[@.spid2 =] 'spid2'

Is another SQL Server process ID number to check for lock information.
spid2 is int, with a default of NULL. spid2 is another spid that may
have a lock at the same time as spid1, and on which the user also
wants information.

Note sp_who can have zero, one, or two parameters. These parameters
determine whether the stored procedure displays locking information on
all, one, or two spid processes.WangKhar (Wangkhar@.yahoo.com) writes:
> Anyone know if this has been resolved? Not hugely important, more
> amusing. Thought I was patched up.

If look in Books Online, on about every topic, there is a mail icon in the
upper left corner. If you click it, you can submit feedback on that
particular topic.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp