Identifying logins that have no passwords Identifying logins that have no passwords SELECT name FROM sys.sql_logins WHERE PWDCOMPARE('', password_hash) = 1 ;