Wednesday, February 15, 2012

Error 21002 [SQL-DMO] User 'already' exists

I have restored a database. Now I am trying to reset permissions on some accounts and this is the error I get. Even when I delete and re-establish acct, I get same thing. Can anyone help
ThanksSeems you want to read about sp_change_users_logins in Books Online. For a GUI on top of the
command, see:
http://www.dbmaint.com/SyncSqlLogins.asp
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"mmitchmcp" <mmitchmcp@.netscape.net> wrote in message
news:1E90A19D-BBB7-4B4A-A7FB-BCFE344A323D@.microsoft.com...
> I have restored a database. Now I am trying to reset permissions on some accounts and this is the
error I get. Even when I delete and re-establish acct, I get same thing. Can anyone help?
> Thanks|||I tried this application and it works great! Thank you

No comments:

Post a Comment