The way to see what logins fit which of these three options is easily done by query the catalog view sys.sql_logins. The following query provides that information: SELECT      [name]   , is_policy_checked   , is_expiration_checked FROM sys.sql_logins; OPTIONSMust change password at next login SELECT LOGINPROPERTY('sa', 'IsMustChange');GO  Result Set Legend 0 - Must not change password at next login 1 - Must change password at next login Expired password  
Leggi tutto il post...