Home Forums SQL Server 7,2000 Backups refresh dev server from prod: how to reconnect logins/users RE: refresh dev server from prod: how to reconnect logins/users
Steve Jones - SSC Editor
SSC Guru
Points: 734314
More actions
August 27, 2004 at 9:57 am
#520907
add the logins to the dev db.
the users will be there once you restore
sp_change_users_login will synch them.