Steve Conklin (Developer@UltraDNT)
Developer at UltraDNT.com
Wed Nov 24 12:24:10 CST 2004
In Ent. Mgr. 2000, right click the source database, then "All Tasks" then "Generate SQL Script." Run the resulting script in QA in the target database. Hth Steve -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Wednesday, November 24, 2004 12:53 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Copy database question I want to copy a database containing 100+ tables, about 500 sprocs and about 200 views and about 20 UDFs to a new database, but with the proviso that no data goes, only the structures. I'm not sure how to do this. Suggestions? TIA, A. > > -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.289 / Virus Database: 265.4.1 - Release Date: 11/19/2004 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com