Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Write your own sp_lock system stored procedure in SQL Server 2005
- The sp_lock system stored procedure is a great tool for checking the amount of locking that occurs on your database system. It returns the number and types of locks that are being held by current active SQL Server sessions. One of my previous articles describes how you can use sp_lock...
- Tags: Procedure, Microsoft SQL Server, Statement, Information, Session, Microsoft SQL Server 2005, LEFT JOIN, Sql_handle, sp_LockDetail Example, Tim, Storage, Databases, Hardware, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-01-07
- << Previous
- page 1 of 1
- Next >>