I've just restored a db (MS SQL 2000) unto MS SQL 2008. All went well and the users for that db were also created. But they were created on the db level.
On the server level, these logins were not there. I tried to create them manually at the server level. When I try to assign the login to the db it understandably says that the user with the same name already exists in the db.
I tried dropping the login created in the db level but I can't do so as there is a schema in the database with the username.
How should I go about getting the same login unto 2008 without dropping any schemas as I am trying to keep everything the same as it was in 2000 for testing purposes in 2008.
Thanks in advance.
View Complete Post