How can I save a database schema without the table data but include views
and stored procedures?  Thanks.

David

Create an empty database, then use a synchronization tool like Red-Gate's
SQL Compare.  It will copy objects but migrating data is a separate step
(and actually uses a different tool, SQL Data Compare).  Once the new
database is ready it should take you all of about 30 seconds to generate all
of the objects.




Show quoteHide quote

Hi David

  You can save the scripts of all the objects in your database.   Right
click on the database, and then select all tasks from the menu.  From
the new menu select the option  Generate SQL Script.

Adi

David wrote:
Show quoteHide quote

http://www.karaszi.com/SQLServer/info_generate_script.asp

Show quote Hide quote

Foreign Key may cause multilple cycles
Bulk Insert from Excel
Sort Numbers in Nvarchar As Numbers
How do I filter out unwanted rows by only one different column?
Orders Per Hour Count