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 - 2005-05-24 : 06:45:50
|
| Mooky writes "I am trying to copy an entire database (tables, objects, etc) from server A to server B. The package fails stating that a certain user or role doesnt exist on the target DB. Problem is that i dont see that user or role defined anywhere on the source server either. What to do?" |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2005-05-24 : 12:08:44
|
| 1. Check in the source database all the objects are created by dbo only.2. Open the database and goto User node and notedown the users list and verify all the users of SourceDB should exists in destination DB also.3. Login with sa (who have sa permissions) then start export the DB objects from one DB to other.still you are facing any issue please let me know with proper error message.With RegardsSreenivas Reddy B |
 |
|
|
|
|
|
Copying Tables And Objects with DTS