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 - 2006-07-11 : 11:19:33
|
| Nalini writes "We had created a set of table and the owner of the tables is a user named prolite. These tables have not been created with dbo as owner.Now I need to convert the owner of the tables to dbo so that I create various logins with restricted access for my team members as well as external to team members.The issue I am facing now is, after change of table owner to dbo the DTS transformation between the columns of the two tables is lost. So if there is any inter linkage between columns (source table to destination table) during dbowner transformation will be lost. So I have to go through all the transformation steps, take the list of tables (because when the dbowner is changed even the table will be lost from selection). Then I have to take the list of the mapping columns under current transformation before dbowner change.We have a lot of packages in our system. I think this is a tedious task and it would take time. Is there any way my work can be minimized? What is the right way of performing this activityThanks in advance for yr help" |
|
|
|
|
|
Loss of transformation steps when table owner is changed