How does SQL Server View the locked table and how to unlock it?

How does SQL Server View the locked table and how to unlock it?

View the locked table:

Select spIdfrom master... SysProcesseswhere db_Name (dbID) = 'database name' and spId <>@spidand dbID <> 0

Unlock:

Exec ('Kill '+ cast (@ spid as varchar ))

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)

The above section describes how SQL Server can view the locked table and unlock the table. I hope it will help you. If you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!