Yup....choose "copy objects and data between SQL Server databases"....then after hitting next you can deselect "copy data".
HTH Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 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: "Ben Densmore" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Tuesday, February 12, 2002 1:13 PM Subject: DTS > Hi All, > Does anyone know if it is possible to transfer a database using DTS but > not transfer the data stored in the Tables? I need to copy a database > over but don't need the data in it, just empty tables and would like to > not have to recreate the tables if possible. > > Thanks, > Ben Densmore > > > ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
