DTS copy databases

• MartinPlant

  Old Hand

  Points: 365

  More actions

  November 22, 2002 at 6:03 am

  #151766

  Hello

  I am trying to copy one DB from one server to another this is successful albeit the owner changes from 'scheme' to 'dbo'. Is there anyway that I can retain the ownership of the db when I transfer the data? I have several of these db's to do on this server and it will drastically cut down admin if I learn how to do this for the first time, Many thanks

• November 25, 2002 at 8:00 am

  This was removed by the editor as SPAM

• philcart

  SSC-Forever

  Points: 47794

  More actions

  November 25, 2002 at 2:59 pm

  #442354

  How are you copying the database? Using the "Transfer Database" or "Copy Objects" task?

  Thanks

  Phill Carter

  --------------------
  Colt 45 - the original point and click interface