The Tech Pursuit: Get all users details on Sql Server

SP_WHO2
It will give all locks on database.

SP_WHO2 <tablename>
It will give all locks on table.

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

Get all users details on Sql Server

No comments:

Post a Comment