Bol error

[WangKhar]

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.

[Erland Sommarskog]

WangKhar (Wa******@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, so****@algonet.se

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