Its only a development server but ...

[fatherjack]

OK, it isnt the end of the world but i have been moving all SQL databases from one server to another in our development environment and think i have screwed up a bit.

In essence, the users in each database are different to the logins in the security tab. IE, there are users in DB1 that dont appear in the logins list. Is there anyway of getting the security information uptodate? I move the databases by detach|file copy|attach into the nice shiny new server. I am running into all sorts of errors when i try to create users in security as it says the user alrady exists ...

all thoughts welcomed, am steeling myself to start all over again!

[MAK]

http://support.microsoft.com/default...b;en-us;246133

+


Check BOL for "sp_change_users_login"

[Rawhide]

When I move a db from 1 server to another, I generally delete the users in the db and then re-add all needed accounts.

This approach works for me because I require that all objects be created with dbo as owner. You can't delete users that own objects in the database. If you have objects owned by users, you have to change the owner to dbo or delete the objects.