Home Forums SQL Server 2008 Security (SS2K8) Enabling "Enforce password expiration" on an account with an old password RE: Enabling "Enforce password expiration" on an account with an old password

  • Well you can alter all the current users by running below code...

    USE master

    SELECT 'ALTER LOGIN ' + '[' + name + ']'+ ' WITH

    CHECK_POLICY = ON,

    CHECK_EXPIRATION = ON; 'FROM sys.sql_logins

    WHERE is_policy_checked = 0

    or is_expiration_checked = 0

    Execute your results and you should be fine!