The Tech Pursuit: How to check lock on database in SQL Server

Run SP_LOCK on query prompt you will get all lock on database.

Disclaimer

This blog is an entirely personal, unrelated to my current, former or future employers. My employer has nothing to do with its content including anything that is posted on this blog.

Information on this site may contain errors or inaccuracies, the blog site’s writer(s) do not make warranty as to the correctness or reliability of this blog site’s content.

If you own rights to any of the images or articles, and do not wish them to appear on this site, please contact us via e-mail and they will be promptly removed.

The Tech Pursuit

Pages

April 24, 2011

How to check lock on database in SQL Server

No comments:

Post a Comment