Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002

    Unanswered: Forcing password change

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

  2. #2
    Join Date
    Aug 2002

    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 haven’t 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts