This one is an oldie but a goodie. I don't remember who originally gave me this, but I've edited it over the years. Works on SQL Server 2000 and 2005.
Purpose: Shows the various locks taken on a system
PingBack from http://msdnrss.thecoderblogs.com/2007/08/15/script-of-the-day-locking-information/