How to Get Rid of SQL Locks. The SQL server is a database management system used for file storage and can be accessed through queries using the SQL language and command prompts. If you have found ...

SQL Server 2008 R2 uses a granular approach to locking. It will select the appropriate locking level based on the number of records affected and other ongoing activities.

OUTER APPLY sys.dm_exec_sql_text (blocker_req.sql_handle) AS blocker_sqltext OUTER APPLY sys.dm_exec_input_buffer (osw.blocking_session_id,0) as blocker_sqltext2; --Details about the locks that are ...