SQL Users with matching passwords
SQL Users with matching passwords
use MASTER go SELECT [name],[type_desc],create_date,modify_date,password_hash FROM sys.sql_logins WHERE PWDCOMPARE(lower([name]),password_hash)=1 --Note: Have experienced where case matters or PWDCOMPARE(upper([name]),password_hash)=1 or PWDCompare([name],password_hash)=1 order by [Name]