Restore deleted user in SQL Server 2000
Posted on 2008-10-28
I need to know how to restore a deleted user. I do have copies of yesterday's backups, and can see the user listed there. However, I am afraid to restore all of the database (overwriting all of the table data), and would like to simply overwrite the user list. Is that possible? I know I could also just re-create the user, but I have run into one problem there. The deleted user is a special admin user whose login is listed as "<none>". Since I can't figure out how to create that (and would further have to re-create every jot and tittle of the user's specific permissions even if that worked), I would REALLY like to know how to get back just that user... or more likely, just the list of users we had as of yesterday (which is when the last backup was done).