jwcolby
jwcolby at colbyconsulting.com
Mon Mar 15 14:54:57 CDT 2010
Copy database is not a choice. Create is but that just creates a database of that name, it does not copy the objects themselves to the new database. John W. Colby www.ColbyConsulting.com David Lewis wrote: > Highlight the db in SSMS, right click and "script database as...". View code and edit as needed. > d. lewis > > Message: 1 > Date: Mon, 15 Mar 2010 13:46:35 -0400 > From: jwcolby <jwcolby at colbyconsulting.com> > Subject: [dba-SQLServer] Copy database > To: Sqlserver-Dba <dba-sqlserver at databaseadvisors.com> > Message-ID: <4B9E727B.3050906 at colbyconsulting.com> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > I need to copy a template database to a new name. Someone mentioned capturing or otherwise viewing > the code that the wizard generates for doing the task. Can anyone tell me how to do this in > sufficient detail that I could actually get it done? > > -- > John W. Colby > www.ColbyConsulting.com > > > The contents of this e-mail message and its attachments are covered by the Electronic Communications Privacy Act (18 U.S.C. 2510-2521) and are intended solely for the addressee(s) hereof. If you are not the named recipient, or the employee or agent responsible for delivering the message to the intended recipient, or if this message has been addressed to you in error, you are directed not to read, disclose, reproduce, distribute, disseminate or otherwise use this transmission. If you have received this communication in error, please notify us immediately by return e-mail or by telephone, 530-893-3520, and delete and/or destroy all copies of the message immediately. > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >