Hi everyone,

I tried to upload my database to my web host. Nevertheless as they do
not give me enough permission to perform some DTS thus I have to
generate script to do it myself. The problem is MSSQL script
generation operation can only generate the definitions of the objects,
no data insertion sql is created.

So is there any method to create insertion script for all the tables
in my database (they have automated increment key as well)

Hope for your response!

Thank you

Nhat,

This might be just what you need:

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

Steve Kass
Drew University

Nhat Yen wrote:

> Hi everyone,
>
> I tried to upload my database to my web host. Nevertheless as they do
> not give me enough permission to perform some DTS thus I have to
> generate script to do it myself. The problem is MSSQL script
> generation operation can only generate the definitions of the objects,
> no data insertion sql is created.
>
> So is there any method to create insertion script for all the tables
> in my database (they have automated increment key as well)
>
> Hope for your response!
>
> Thank you

Kass, thank yoouuuu very much, it provides much help to me!

Nhat Yen!

Steve Kass <skass@drew.edu> wrote in message news:<DE1Kc.5104$mL5.2705@newsread1.news.pas.earth link.net>...
> Nhat,
>
> This might be just what you need:
>
> http://vyaskn.tripod.com/code.htm#inserts
>
> Steve Kass
> Drew University
>
> Nhat Yen wrote:
>
> > Hi everyone,
> >
> > I tried to upload my database to my web host. Nevertheless as they do
> > not give me enough permission to perform some DTS thus I have to
> > generate script to do it myself. The problem is MSSQL script
> > generation operation can only generate the definitions of the objects,
> > no data insertion sql is created.
> >
> > So is there any method to create insertion script for all the tables
> > in my database (they have automated increment key as well)
> >
> > Hope for your response!
> >
> > Thank you