How to unlock table in sql server 2019

Locks in MS SQL Server are one way to ensure the integrity of data when changes are made by multiple users at the same time.

MSSQL locks objects on a table when a transaction starts and releases the lock when the transaction ends. In this article, we will learn how to find locks in the MS SQL Server database and remove them.

It is possible to simulate a lock on one of the tables using an unfinished transaction (one that has not been completed by rollback or commit).

For example, use the following SQL query:

Before any changes are made, SQL Server will lock the table. Now try opening SQL Server Management Studio and executing a simple SQL select query:

The query will freeze in the “Executing query” state until it timed out.

This is because the SELECT query is trying to access data in a table that is locked by SQL Server.

To get a list of all blocked queries in MSSQL Server, run the command