Table Data Export To .sql File.

Rookie qustion here quys,

Using SQL Sever 2005 Express and Visual Web Devoloper Express.

I'm trying to get data from my local SQL sever database to my shared hosting database. SImple enough but...

1.) GoDaddy does not allow remote connections to the DB server

2.) With GoDaddy you can't just upload an .MDF file to your remote directory and script a connection string. You have to reference the DB server. Can't upload DB file to DB server.

As a work around, I've seen several .sql files that have all the T-SQL that will create a database and tables then insert the data. I've google'd extensively and searched several forums with no luck as to how to export my local data to file. I could then copy and paste into an online utility GoDaddys has to insert the data.

Is there a relatively easy way to export table data to a .sql file??? When I try using SQL Server Management Studio Express and "Scipt Table As> Insert To> File", It just gives me something like the following...

INSERT INTO [pubs].[dbo].[authors]
           ([au_id]
           ,[au_lname]
           ,[au_fname]
           ,[phone]
           ,[address]
           ,[city]
           ,[state]
           ,[zip]
           ,[contract])
     VALUES
           (<au_id, id,>
           ,<au_lname, varchar(40),>
           ,<au_fname, varchar(20),>
           ,<phone, char(12),>
           ,<address, varchar(40),>
           ,<city, varchar(20),>
           ,<state, char(2),>
           ,<zip, char(5),>
           ,<contract, bit,>)

Plenty of data in this table, no data in script   ???

Can SQL Server Management Studio Express do what I wanting to do? If not, any suggestions? Know of a better hosing company?