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?
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.