Locks In Sql Server. A lock is established in sql server when a transaction starts, and it is released when it is ended. If you are more comfortable using sql server management studio to review locking and blocking as opposed to querying system objects or executing stored procedures, you are in luck.

Here is a quick script which will help users to identify locked tables in the sql server. There are different types of locks are there. Select balance from tbl_account where acct_number = 25.