Forcing password change

Is there a way in Sql Server 2000 to enforce the password change to the sql autheticated user?Hi,

There is now setting you can configure to do so. But master..syslogins has a column (updatedate) so you could make a job that select every login that havent change their password for, let say for a, month.

Select loginname from master..syslogins where datediff(Month,updatedate,getdate())>1


Now you can decide if you make a cursor that change all the password (which givs you the problem to tell the users) or you email (job too perhaps) them and ask them change themself.

I hope this is useful
/Madasql