Will this also work in 2008?

USE Master

GO

SELECT [name], sid, create_date, modify_date

FROM sys.sql_logins

WHERE [name] = 'sa'

GO

Another way to know whether change password setting was enforced or turned off. Right?

Will PWDCOMPARE help then?

A. logins that have no passwords

1SELECT name FROM sys.sql_logins

2WHERE PWDCOMPARE('', password_hash) = 1 ;

B. for passwords which are same as login names

1SELECT name...

Thanks,

I just read online the following:

With SQL Server 2008, password policy enforcement is built into the server. Using the NetValidatePasswordPolicy() API, which is part of the NetAPI32 library on Windows...