See Re: Restore / User already exists Thread #809201 Message #809243

>I have moved a SQL 7.0 db to a new SQL 2000 machine/server. The logins came over, but the DatabaseAccess properties did not. When I try to manually update the DatabaseAccess properties I get an error 'Error 21002: [SQL-DMO] User 'name' already exists.' It will not let me change the properties of the login.
>
>I have not been able to find any 'known problems' issues on this. Any ideas?