kaiser18au
Technical User
Hi everyone,
Just a quick question. I am trying to do a DTS to pull data across the network from a database on one server to another.
The database has many tables. There are 3 owners to the tables. Owner1 owns 1/3 of the tables and Owner2 owns 1/3 and Owner3 owns 1/3. Some table names are the same, but are qualified by table owners.
When I do DTS, I cant get the owner details to come across. The ownership of the table revert to DBO. As a consequence, some tables are not created as it complains some table names already exist as its not qualified by owners anymore.
Can anyone help?
Much appreciated.
Kaiser
Just a quick question. I am trying to do a DTS to pull data across the network from a database on one server to another.
The database has many tables. There are 3 owners to the tables. Owner1 owns 1/3 of the tables and Owner2 owns 1/3 and Owner3 owns 1/3. Some table names are the same, but are qualified by table owners.
When I do DTS, I cant get the owner details to come across. The ownership of the table revert to DBO. As a consequence, some tables are not created as it complains some table names already exist as its not qualified by owners anymore.
Can anyone help?
Much appreciated.
Kaiser