Friday, August 1, 2014

SQL Login is locked? instead of looking at one at time on SSMS. Here is the script that will check all SQL Sever login at same time .


select name,
'Status' = CASE (select LOGINPROPERTY(name,'islocked'))
WHEN 0 THEN 'Unlocked'
WHEN 1 THEN 'Locked'
WHEN NULL then ' '
END
from master..syslogins
where isntname = 0

Thanks

No comments:

Post a Comment