Home Forums SQL Server 2005 Administering How to sync users and logins in SQL2005 after restore RE: How to sync users and logins in SQL2005 after restore

  • Thanks, but according BOL:

    Windows groups and Windows users

    are not reconnected. (BOL:

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/11eefa97-a31f-4359-ba5b-e92328224133.htm

    sp_change_users_login cannot be used with Windows logins.

    )

    So your script probably won't work, because you use the sp_change_users_login stored procedure.

    I will try later.