Thursday , April 18 2019
Home / DataBase / SQL SERVER / How to find locked tables in sql server

How to find locked tables in sql server

In multiuser environments, sql server ensures the integrity of the data by setting write locks on all the tables(Locked tables) when you are updating. This prevents other users from making changes to the same tables.

if the table is locked we cannot do any CRUD(insert/select/update/delete) operations on table until it is unlocked

so if we want find locked tables in sql server we can use below query

it will return locked tables list along with sessionid

if we want to kill session use below query then automatically tables will be unlocked



We hope you find the tip as helpful,  I hope you liked the article. Please share your valuable suggestions and feedback in the comments


Print Friendly, PDF & Email

Give us your valuable feedback


About Murali

Hello everyone I am Software Developer having 3+ years of Experience in Microsoft Technologies and Others. My skills :-, C#,, SQL SERVER, web services, windows Service,Windows applications,HTML,CSS, JavaScript,JQuery,AnjularJs

Check Also

Find all rows count and columns count in single database in sql server

In General for any database it contains lot of tables, if we want to find …