TSQL to find if logins have password same as loginname?

Question

Hi

I want to check if SQL logins have passwords same as thier login name. E.g. login name 'abc123' has password= 'abc123'. I need to do this for a security audit across many 2000 and 2005 servers.

Is it possible to check using TSQL?

Thanks in advance

Answer 1

select * from syslogins where pwdcompare (name,password)=1

BOL: pwdcompare