Pau Lo
asked on
Password Policy
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.