You have to make sure you don't select the default option of just copying the tables and data during the DTS process. There is a screen with 2 or 3 options (after you've selected source, destination, and the tables I think). Make sure you select the option that mentions copying all objects etc.
Sorry to be a tad vague...it's been awhile ;-) HTH Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Phoeun Pha" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 04, 2002 7:56 AM Subject: OT: SQL Server Export > Hey guys, > > whenever i do an export of tables from one DB to another, it never copies > the table attributes, such as default value, for example. I have many > instances where the default value is needed. Can someone let me know how to > do this? maybe i missed a step in the DTS > > > thanx > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
