SQL Server Performance Forum – Threads Archive
Logins with null passwordsWhy does this script return logins with null passwords, even when I’m sure the passwords in some cases are not null USE MASTER
Select name, password
where password is null
order by name
I think it returns the windows builtin users with null passwords.
No, it just refuses to show you the actual password! If the password is null, then the password column will say NULL – which is a bit inconsistent, but it does show you which logins do not have a password. Ranitjain is correct that the password returned for Windows logins will always be null here. CORRECTION:
If the password is shown as a blank then it’s a SQL Server login, if it’s shown as NULL then it’s a Windows login.