Instead of selecting - 'Copy tables and views from source', choose 'copy objects and data'. You will have more control over what objects are to be copied. This way your default values as well as primary key designations will also get copied. Be careful though; with this method, it is quite possible to copy various objects that are not needed and also drop similarly named objects in your destination database.
Dharmesh Goel Programmer Analyst IT Dept. - Discount Car & Truck Rentals 416-744-0123 x290 -----Original Message----- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: September 4, 2002 10:57 AM To: CF-Talk 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 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists