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!