SQL single-user lock table unlock, SQL unlock

SQL single-user lock table unlock, SQL unlock

USE master;
GO

DECLARE @ SQL VARCHAR (MAX );

SET @ SQL =''

SELECT @ SQL = @ SQL + '; KILL' + RTRIM (SPID)

FROM sysprocesses

WHERE dbid = DB_ID ('wms. MDF ');

EXEC (@ SQL );

GO

Alter database [WMS. MDF] SET MULTI_USER;

 

View the locked table:

Select request_session_id spid, OBJECT_NAME (resource_associated_entity_id) tableName
From sys. dm_tran_locks where resource_type = 'object'

Spid lock table process
TableName: name of the table locked

Unlock:

Declare @ spid int
Set @ spid = 57 -- lock table process
Declare @ SQL varchar (1000)
Set @ SQL = 'Kill '+ cast (@ spid as varchar)
Exec (@ SQL)