In SQL 2005, is there a table/query that can be run to:
Identify each sql server authentication accounts associated password policy, i.e. min password length, account lockout, password expiration etc. I want this for every account.
Also is there any query that can be used to find the location on file of any backups or copies of a SQL database? And where they reside? At present I get a directory listing /DIR but it takes an age to filter through.
As a general rule, would you have password expiration against sa accounts and backup accounts? If not why not?