Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Red face Unanswered: DTS Import/Export Wizard

    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.

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    The most logical solution :

    Register the server in EM with the login A. All tables will now be created with owner as A

  3. #3
    Join Date
    Oct 2003
    Posts
    2
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •