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 |
|
mdesai2005
Starting Member
4 Posts |
 Posted - 2005-05-23 : 15:43:14
|
I am trying to run a DTS package that copies all tables and objects from Server.DB A to Server.DB B. It keeps failing in the middle stating that "User or Role 'x' doesnt exist in this database". Problem is that i cant seem to find any record of that user/role in the source database. Any ideas?? Thanks in advance. Mooky |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2005-05-23 : 17:50:52
|
| Before you start DTS Process, Check in your source database tables make sure that all the tables created by DBO object only. Suppope if any table (s) are created by XUser then you need to create that user also at the destination first.Try this if not mail me in detail .....With RegardsSreenivas Reddy B |
 |
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2005-05-24 : 17:40:05
|
| Here's an easy way.In EM, DTS import/export wizard, choose "Copy objects and data between SQL Server databases" option. On the next step, uncheck "Use default options" checkbox, click Options button, uncheck all in "Security options" section.Then save DTS Package, so you can take a look at how EM did it.Donn Policarpio |
|
|
|
|
|
|
DTS Package Failure