Monday , December 11 2017
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

 

Conclusion:

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

comments

About Murali

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

Check Also

dbForge-Studio-for-SQL-Server

dbForge Studio for SQL Server – Ultimate SQL Server Manager Tool from Devart

dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, …

%d bloggers like this: