Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    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
    Posts
    20
    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 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
    /Mada

Posting Permissions

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