Hi all,

I would like to retrive system report that provides the following security configurations for MS SQL

1. Minimum Password Length

2. Initial log-on uses a one time password

3. Password composition (e.g., alpha/numeric characters, not words in

dictionary)

4. Frequency of forced password changes (password expiration/aging)

5. The number of unsuccessful log-on attempts allowed before lockout

6. Ability of users to assign their own passwords

7. Number of passwords that must be used prior to using a password again

(password history)

8. Idle session time-out

9. Logging of unsuccessful login attempts

do i have to script it or is there any alternate option

thanx in advance