May 10, 2003 at 2:06 am
Scenario:
A sql 7 development database "sql7dev" has a login, Marcy.
On a seperate sql 2k box, I restored sql7dev to "sql2kprod". Before the restore neither the database or Marcy existed on the sql 2k box. After the restore, Marcy appears under Enterprise Manager as a login.
BUT when I try to give her read permission to sql2kprod I get:
"Error 21002: SQL-DMO User "Marcy" Already Exists"
That's right -- she exists. But I'm only trying to change her permissions not recreate the account.
To get around this problem I delete her login and name from Users. Assuming she doesn't also belong to a database role
I can then add her account to sql 2k box and assign permissions.
Question: is there a better way of handling this? The above approach seems like too much tweaking and fiddling around involved for a single user.
May 12, 2003 at 7:13 am
Have you tried to use sp_change_users_login?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply