Can someone explain how could I crate a script of a database? I want to save
a Table from a database, so I could play with it and be able to restore it
back as required. I have seen some databases saved as scripts, like
Northwin.sql. I have look for examples on how to create these scripts of the
tables or databases, but I haven't found anything.

You open Enterprise Manager and right click on the database node and choose
"All Tasks" then "Generate SQL Script". From there you can choose which
objects to script and what options you need.

--
Andrew J. Kelly SQL MVP


"HLong" <HLong (AT) discussions (DOT) microsoft.com> wrote

Yes, it works fine. However, I can't fine a way on scripting the data with
INSERT staments so the entire table or datable could be recreated. How could
I do this?

"Andrew J. Kelly" wrote:

There are tools out there to do this and young
Vyas(http://vyaskn.tripod.com/code.htm#inserts) has a series of statements
you can run also. It also begs the question that if you want to take the
structure AND the data then would a BACKUP not be more appropriate?



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"HLong" <HLong (AT) discussions (DOT) microsoft.com> wrote

Try www.sqlscripter.com to generate T-SQL data scripts.
Its free


"HLong" wrote: