title: CREATE LOGIN check_expiration and check_policy
body: <p>Just to know If I understood this correctly, both <strong>check_policy</strong> and <strong>check_expiration</strong> are taken from the Windows settings?</p>
  
  <p><a href="https://i.stack.imgur.com/mupBG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mupBG.png" alt="enter image description here"></a></p>
  
  <p>If I ever change the <strong>maximum password age</strong>, that would represent the check_expiration by default? and "<strong>password complexity requirements</strong>" represent the check_policy?</p>
  
  <pre><code>CREATE LOGIN [Stackoverflow] WITH PASSWORD=N'azeqsd789' MUST_CHANGE, DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON, CHECK_POLICY=ON
  </code></pre>