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.
Showing posts with label stated. Show all posts
Showing posts with label stated. Show all posts
Friday, February 17, 2012
Subscribe to:
Posts (Atom)