Post reply

Trying to reset a user password error

  • June 29, 2009 at 11:14 am

    #1016997

    I am trying to only reset a user's password so i can't put the old

    This worked !

    sp_password NULL, 'new_password', 'user'

    How can i force the password to be changed at first login ?

  • June 29, 2009 at 11:19 am

    #1017002

    exec sp_password @new = 'password', @loginname = 'username'

  • June 29, 2009 at 11:21 am

    #1017005

    I had to put NULL for the old password parameter,

    how can i force a change when the user logs in , the equivalent of MUST_CHANGE in sql2005

  • June 29, 2009 at 11:25 am

    #1017007

    jrmtl (6/29/2009)

    I had to put NULL for the old password parameter,

    how can i force a change when the user logs in , the equivalent of MUST_CHANGE in sql2005

    You can't.

  • June 29, 2009 at 11:33 am

    #1017014

    ok fair enough ...

    Thanks a bunch for your help !

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply