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. /* usc_DBA_Show_Lock_Types.sql Author: Unknown Purpose: Shows the various locks taken on a system */
