Re: Must_Change Option

Hi
Have a look at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/scsql9/html/c0040c0a-a18f-45b9-9c40-0625685649b1.htm



"CBKowitz" <CBKowitz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:458A2231-84FF-4292-901B-59A553B14C2D@xxxxxxxxxxxxxxxx
How do you turn this option off? I created a login and didn't realize
that
is option was on. Now if I try to run this command: alter login UserID
with
check_policy=off, check_expiration=off

I get this error: Msg 15128, Level 16, State 1, Line 1
The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when
MUST_CHANGE is ON.

But from what I can tell there is no way to set MUST_CHANGE=Off

Thanks.


.