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]

Leave a Reply