Record insertion

[Nhat Yen]

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

[Steve Kass]

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

[Nhat Yen]

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

Nhat Yen!

Steve Kass <sk***@drew.edu> wrote in message news:<DE*****************@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