Change Password After 1st Login

I've tried Books Online, MSDN online and google but cannot get the answer.
Can I get ann SQL account configured such that the user will have to change
the next time they login.
Apologies if this is a simple flag somewhere but I can assure you I have
tried to find the answer.
Any help welcome.
MPMForgot to mention SQL 2000 + SP3a
"MANCPOLYMAN" wrote:
> I've tried Books Online, MSDN online and google but cannot get the answer.
> Can I get ann SQL account configured such that the user will have to change
> the next time they login.
> Apologies if this is a simple flag somewhere but I can assure you I have
> tried to find the answer.
> Any help welcome.
> MPM|||You can't do this in SQL2000. You will be able to do this in SQL2005 using
the MUST_CHANGE option for CREATE/ALTER LOGIN.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:86EFDFC9-3AAE-4397-8722-671962F54AB1@.microsoft.com...
> Forgot to mention SQL 2000 + SP3a
> "MANCPOLYMAN" wrote:
>> I've tried Books Online, MSDN online and google but cannot get the
>> answer.
>> Can I get ann SQL account configured such that the user will have to
>> change
>> the next time they login.
>> Apologies if this is a simple flag somewhere but I can assure you I have
>> tried to find the answer.
>> Any help welcome.
>> MPM