You can download a free T-SQL script to do this:

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

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Terri" <Terri@spamaway.com> wrote in message
news:c10ufs$v54$1@reader2.nmix.net...
> I'd I have a problem I'd like to post CREATE TABLE and INSERT statements
> that will create my table and insert data into the table.
>
> I can use the scripting feature in Enterprise Manager to generate CREATE
> TABLE scripts.
>
> Is there a script I can run that will generate INSERT statements so I can
> include sample data.
>
> Thanks
>
>