Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Login and Database User

Author  Topic 

cidmi.dovic
Yak Posting Veteran

53 Posts

Posted - 2007-06-12 : 04:13:42
Hi,

I've backuped a database.
When I restore this db in other Sql Server 2000 it imports the users.

How can I associate these users to logins on db, when I try I always have the message : "The user already exists". If I try to delete the user and create it again I can't because "The user owns objects"

Thank you in advance.

TonyTheDBA
Posting Yak Master

121 Posts

Posted - 2007-06-12 : 06:34:57
You Could Try [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=84730[/url]

--
Regards
Tony The DBA
Go to Top of Page
   

- Advertisement -