[dba-SQLServer] Copy a database using a store procedure or function

I know it's a pain to learn, but SSIS (integration services) can do just about everything you need to do.Nancy Lytle N_Lytle at terpalum.umd.edu

> From: jwcolby at colbyconsulting.com> To: dba-sqlserver at databaseadvisors.com> Date: Tue, 25 Mar 2008 14:05:32 -0400> Subject: [dba-SQLServer] Copy a database using a store procedure or function> > I have built up a template database which has views that pull data out of> many different databases / tables. Additionally I now have user stored> procedures which perform processing steps. In real life I manually copy> this template database to a new name using the copy database wizard, and> then run the stored procedures and stuff to build up a data order for> shipment. > > What I really need to do is have a method of copying this database to a new> name and then "use" that database to launch the various stored procedures> inside of it to fill the tables, build the data and export the data.> > Is there a function or sp which can copy a database to a new name? When I> Google I get about a million "use the copy database wizard" answers.> > John W. Colby> Colby Consulting> www.ColbyConsulting.com > > _______________________________________________> dba-SQLServer mailing list> dba-SQLServer at databaseadvisors.com> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> http://www.databaseadvisors.com> 
_________________________________________________________________
Test your Star IQ
http://club.live.com/red_carpet_reveal.aspx?icid=redcarpet_HMTAGMAR