MSSQL LockInfo #tools


Thomas Titus
 

Hi Folks,
I have uploaded a MSSQL Stored procedure LockInfo() to the file area (https://magicu-l.groups.io/g/main/files/LockInfo.zip ).
This stored procedure lists actual data of the locked record along with user name, table name, hostname, duration of the lock etc.
FYI
Thanks
Thomas Titus.


 

maybe change:
ALTER PROCEDURE [dbo].[LockInfo]
to:
CREATE PROCEDURE [dbo].[LockInfo]

It's nice, most people who work with MS-SQL will have the need for someting like this.

A example of the output: