How to Release a lock on Table in SQL Server. Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg
By the Way to Terminate a Session is used to Release a Lock in a Table. In this Video we used KILL Statement to Release a Lock.
KILL can be used to terminate a normal connection, which internally terminates the transactions that are associated with the specified session ID. So, Transaction automatically gets Rolled back and Lock will be Released.
Tags: How to Release a lock on Table in SQL Server, Kill in SQL Server, Terminate User Session in SQL Server, Terminate Process in SQL Server, Terminate Lock in SQL Server, Remove lock in SQL Server