Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
In SQL Server 2000,
sp_lock is used to find dead lock inside the database.if any dead lock occur then using "Kill spid" is to remove the dead lock.