Getting account 'locked' status in MS SQL Server
- by Santhosha
I want to unlock one account in MS SQL Server. Before unlocking I have to check whether that account is locked or not.
I want to unlock only if the account is locked.
Is there any SQL query or stored procedure to get the "Locked" status of SQL user?