Query to determine if Enforce Password Policy is on

  • I think this is only relevant to SQL Server 2005, but I would like to write a query to determine is the Enforce Password Policy is on...what table is this stored in? Do any of you have a query that already does this. Thanks

    -Kyle

  • select name, is_policy_checked

    from sys.sql_logins

    --where name ='LoginName'


    * Noel

  • Is it a correct assumption that the password policy is new to 2005?

    -Kyle

  • YES


    * Noel

  • select name, is_policy_checked

    from sys.sql_logins

    -When I use this query, it doesn't pick up the windows authenticated users.

    -Kyle

  • Windows users are *always* bound by windows password policies


    * Noel

Viewing 6 posts - 1 through 5 (of 5 total)

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