Here's an enhanced version of sp_lock which shows additional details like names of users, hostnames and databases. http://support.microsoft.com/defaul...ticles/Q255/5/96.ASP&NoWebContent=1#appliesto I'd like to see more enhancements into sp_lock. For example I want it to show me only those locks that are waiting to be acquired.
