Re: Table export removes primary key On the next screen after specifying the destination server in DTS
import/export wizard, select the third option "Copy objects and data between
SQL Server databases", on the next screen, uncheck the "Use default options"
check box, click on the options button. A dialog box will provide the
required options to copy the keys, indexes, triggers etc.
--
Anith |