Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jshurak
Starting Member
44 Posts |
 Posted - 2006-11-22 : 08:02:54
|
| We have two users that were mistakenly deleted from our production server. we have backups from the night before the deletion including the master database. I restored all the user databases from the production server to the test server. The users now are in the system tables in the users database. Is there a way to restore them into the syslogins table from my current situation?Jshurak - The International Businessman of Mystery |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-11-23 : 02:03:08
|
| yes you canfirst execute sp_change_users_login 'Report' stored procedure which gives report on orphaned users.then execute sp_change_users_login 'Auto_Fix', 'user' stored procedure..this method is feasible if there are less number of orpahned users like in your case..if there are many users then you have many scripts available to care of this taskits me monty |
 |
|
|
|
|
|
Restoring users