April 24, 2011

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.

No comments:

Post a Comment