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 Development (2000)
 DBO Rights

Author  Topic 

Rita Bhatnagar
Posting Yak Master

172 Posts

Posted - 2001-09-24 : 12:46:02
We created new server for sql2k because old server was down and then transfer all the information to the new one.
When we add new user it comes with the error 'name can't be found in the user collection'. But it adds the user to database and gives dbo rights for two databases. For the third one user was unable to get dbo rights and he is stuck.
what is going on ?
Thanks for any help.
Rita



   

- Advertisement -