Post reply

Query to determine if Enforce Password Policy is on

  • September 6, 2007 at 2:43 pm

    #180944

    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

  • September 6, 2007 at 2:53 pm

    #731974

    select name, is_policy_checked

    from sys.sql_logins

    --where name ='LoginName'


    * Noel

  • September 6, 2007 at 2:55 pm

    #731975

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

    -Kyle

  • September 6, 2007 at 2:56 pm

    #731976

    YES


    * Noel

  • September 7, 2007 at 7:46 am

    #732142

    select name, is_policy_checked

    from sys.sql_logins

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

    -Kyle

  • September 7, 2007 at 12:07 pm

    #732245

    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