背景：

新建了用戶，沒有取消掉強制密碼策略

修改掉策略報錯

錯誤：

The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.

使用代碼修改：

USE Master GO ALTER LOGIN [somelogin] WITH PASSWord = ‘samepassword’ GO ALTER LOGIN [somelogin] WITH CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF;