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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-29 : 09:32:44
|
| justin writes "I have a few server set up that has a 100 users or so. When I back up a database and try to move it to another server using the .bak file I am having problems keeping the same username for the database. I get the error the user owns objects in the database. My question is how can I move the database with the without DTS and keep the same username?" |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-05-29 : 09:38:23
|
Hmmmm.You're mixing statements in your question. First, the # of users has nothing to do w/ your problem. Second, databases don't have user names. The specific error message you're getting occurs when you try to remove a user definition from the database when that user owns objects in the database ( who would own them then? ).The solution would be a) don't delete the user, or b) assign the ownership of the object(s) in question to a different user. BOL can help you out with that.quote:
justin writes "I have a few server set up that has a 100 users or so. When I back up a database and try to move it to another server using the .bak file I am having problems keeping the same username for the database. I get the error the user owns objects in the database. My question is how can I move the database with the without DTS and keep the same username?"
setBasedIsTheTruepath<O> |
 |
|
|
|
|
|
multi users