Post reply

password expiration and password policy

  • November 18, 2008 at 2:22 pm

    #215523

    Hi All,

    How would be able to query any of the system table to check whether the SQL Log has the enforce password policy and enforce password expiration check boxes on/off.

    Can some one suggest me the way to find that ? As I have more than 20 login in 50 servers and it will be tedious to do one after the other.

    Thanks,

    Ganesh

  • November 18, 2008 at 2:31 pm

    #900176

    This is will tell you what SQL Server logins have either turned off:

    SELECT name

    FROM sys.sql_logins

    WHERE is_policy_checked = 0

    OR is_expiration_checked = 0

    K. Brian Kelley
    @kbriankelley

  • November 18, 2008 at 3:22 pm

    #900205

    Thanks....I missed those columns.

    Thanks for your help

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

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