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
