I have a problem here with my DTS Import/Export Wizard, according to MSDN Library stated below,
[When creating a table using the DTS Import/Export Wizard or DTS Designer, the owner of a table created at the destination is the current user (generally the dbo), regardless of who the owner is at the source. ]
My concern here is if i have a source table of owner A, how can I default the owner of a table created at the destination is A. The problem here is i have more that 20 table of owner A to transfer and i don't want the default to be dbo and i have to go and change each and everyone. Please advice.The most logical solution :
Register the server in EM with the login A. All tables will now be created with owner as A|||Originally posted by Enigma
The most logical solution :
Register the server in EM with the login A. All tables will now be created with owner as A
I had tried this logical solution. And it still give me dbo instead of user name A.
I try to import/export within the same server and i register the server using user A.
Please revert. Thank you very much.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment