<div>
Hi <br />
<br />
To check for lock you can look at the store procedures sp_who &amp;&nbsp;sp_lock
</div>


Hi

To check for lock you can look at the store procedures sp_who & sp_lock

<div>
Hi<br />
<br />
To unlock have a look at the below links<br />
<br />
<br />
<a href="https://redmondmag.com/Articles/2011/01/01/SQL-Server-2008-R2-Unlock-the-Locks.aspx" rel="ugc">https://redmondmag.com/Articles/2011/01/01/SQL-Server-2008-R2-Unlock-the-Locks.aspx</a><br />
<a href="http://www.exacthelp.com/2012/08/how-to-release-or-remove-lock-on-table.html" rel="ugc">http://www.exacthelp.com/2012/08/how-to-release-or-remove-lock-on-table.html</a><br />
<a href="http://blog.sqlauthority.com/2008/08/18/sql-server-detailed-explanation-of-transaction-lock-lock-type-avoid-locks/" rel="ugc">http://blog.sqlauthority.com/2008/08/18/sql-server-detailed-explanation-of-transaction-lock-lock-type-avoid-locks/</a>
</div>


Hi

To unlock have a look at the below links


https://redmondmag.com/Articles/2011/01/01/SQL-Server-2008-R2-Unlock-the-Locks.aspx [https://redmondmag.com/Articles/2011/01/01/SQL-Server-2008-R2-Unlock-the-Locks.aspx]
http://www.exacthelp.com/2012/08/how-to-release-or-remove-lock-on-table.html [http://www.exacthelp.com/2012/08/how-to-release-or-remove-lock-on-table.html]
http://blog.sqlauthority.com/2008/08/18/sql-server-detailed-explanation-of-transaction-lock-lock-type-avoid-locks/ [http://blog.sqlauthority.com/2008/08/18/sql-server-detailed-explanation-of-transaction-lock-lock-type-avoid-locks/]

<div>
Can you be more precise on what you want to do?<br />
There are few ways to check and prevent locks.<br />
What you mean with remove locks? Tuning the query to prevent future locks or kill the blocking process?
</div>


Can you be more precise on what you want to do?
There are few ways to check and prevent locks.
What you mean with remove locks? Tuning the query to prevent future locks or kill the blocking process?

<div>
<div class="content wysiwyg-content">
Hi experts,<br />
How do you check for, and remove locks in SQL Server 2008 R2?<br />
<br />
<br />
Thanks in advance,<br />
mrotor
</div>
</div>


Hi experts,
How do you check for, and remove locks in SQL Server 2008 R2?


Thanks in advance,
mrotor

How do I check or remove locks from SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.