Since i need to restore my database to another machine, I am now encountering a problem with my db.
Because some login does not exist on the new machine and I need to re-crerate the login in it. However, i found an error message 'User ?? already exist'
Is it possible that i could drop my existing user but some of them are objects/db owner.
many thanks!You got the same problem as me.. see http://dbforums.com/t547764.html|||Originally posted by Nigorr
You got the same problem as me.. see http://dbforums.com/t547764.html
I just find a solution and it fixed my situation and hope it could help you.
I used the sp_change_users_login to associate the login and user.|||thanks, why didn't they(MS) provide a way to do this in enterprise manager?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment