Post reply

query for showing password policy settings

  • April 6, 2009 at 11:37 am

    #202533

    I need to create a report showing all SQL Authenticated users on a given server, and the settings of 'Password Policy Enabled' and 'Password Expiration Enforced'.

    I know that I can visually see these if I right-click on each login; but I'm looking for a query so that I will be able to do this programmatically.

    I've looked in syslogins, and this does not seem to be stored there...

    Any help would be appreciated!

    thanks

    Win

  • April 6, 2009 at 11:46 am

    #972773

    just found it... it's in sys.sql_logins

    this script has it (along with a bunch of other stuff): http://www.sqlservercentral.com/scripts/31776/

    thanks

    W

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply