Hi All,

I am trying to script out a whole SQL SERVER database with all objects
in it along with INSERT Statments to populate data into the table.  My
goal is to have one single file which I can just run and produce the
same structure in a new system.

I do not know if there is a way to do that. If there is, I would really
appreciate if any of you can let me know.

Thanks

-- CC

Don´t know which SQL Server version you are using but for SQL2k5 the
new namespace from SSIS offers something to do that programmatically.
Anyway, if you don´t want the tools and want to do that the old
fashioned way, there is a script from vyaskn which produces the
statement from TSQL:

http://vyaskn.tripod.com/code.htm#inserts


HTH, Jens Suessmeyer.

How to group on half-hour increments on a datetime field?
calculate base 32 notation from int value?
Help with a loop to collect database names and tables within those databases.
Stored Procedure to Make One Table Match Another
Adding Serial No in the Query Resultset