- Is there a way to find logins with blank (NULL) passwords? In SQL 2000, I could use Syslogins table to query for password = NULL but in SQL2005 and 2008, NULL passwords have a value in the password column.
- Is there are a way to globally enforce password policy (complexity, expiration etc) which was introduced in SQL2005? I know we can set for each login but if we wanted to enforce the policy globally (at GPO level or SQL Instance level) can we do it such so that when someone creates a login password policies (and complexity) are enforced? In other words there will not be a choice to not use password policies.