Identifying logins that have no passwords

Identifying logins that have no passwords

SELECT name FROM sys.sql_logins   
WHERE PWDCOMPARE('', password_hash) = 1 ;

 

Leave a Reply

Your email address will not be published. Required fields are marked *