Hi all.
We do have a lot of DB's on our server. This is a copy of customer DB's with
Test data, but customized tables and prosedyres. We do take a standard
database backup of thes every day, but the data it self is of no importanse.
To reduse size we wonder if there is a way of automatic skript all the tables
(not systemtables) and all the stored prosedures out to a file. If we need to
restore some of this we just create a new DB with the testdata and run table
an SP skript. 2 skriptfiles take a lot less space than a full DB backup.

Signature
Thanks all
Regards Geir
ML - 18 Jul 2008 11:12 GMT
Which version of SQL Server?
In SQL Server Management Studio you can use the Scripting Wizard.
Right-click the database node, then under Tasks select Generate Scripts.
ML
---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/