create script

hi,

I gotta get my website online and since I can't connect to the host their SQL server I have to export the data in another way.
I'm realy no SQL-server expert so I am asking, is there a way to generate a script with the initial data?
I allready gave them a script to create the tables, stored procedures, views and stuff.

some additional info.... I use SQL server 2000 and they use sql server 7.

thanks.........

H.J.

Why don't ask them backup the db for you and ftp the backup file to you?

wel I gotta get the data to them. and since they have SQL server 7 it isn't possible to restore a back-up made in sql-server 2000

You can use Generate SQL Script to script the whole database and every object in it. Then you can DTS the data out to text files.

thanks, very helpfull.