title: How to revert the MUST_CHANGE in ALTER LOGIN SQL Statement?
body: <p>Let's say that someone executes the result from the select:</p>
  
  <pre><code>ALTER LOGIN [myLOGIN] WITH PASSWORD = 'myPassword' MUST_CHANGE, CHECK_POLICY = ON;
  </code></pre>
  
  <p>How is the correct way to execute a new <code>ALTER LOGIN</code> statement, which removes the <code>MUST_CHANGE</code> policy? Is something like this ok or there is another better practice:</p>
  
  <pre><code>ALTER LOGIN [myLOGIN] WITH PASSWORD = 'myPassword' MUST_CHANGE, CHECK_POLICY = OFF;
  </code></pre>