How does SQL Server View and unlock a table?

 

Use mastergo -- retrieve the deadlock process select spid, blocked, loginame, last_batch, status, CMD, hostname, program_namefrom sysprocesseswhere spid in (select blocked from sysproceswhere ses blocked <> 0) or (blocked <> 0)

 

Yes.

Select request_session_id, object_name (resource_associated_entity_id) tablename from SYS. dm_tran_lockswhere resource_type = 'object'

Kill process number (sp_lock/sp_who searches for deadlocked processes and objects)
Spid is the process of locking the table.
Tablename is the name of the table to be locked.
Unlock
Kill [spid]