My webapp www.whatpub.org is hosted with WebHost4Life who use MyLittleTools v.2.0 r.096. I have to use the web based query analyser because my ISP (Virgin Media) block the SQL port due to virus threat.

I often have to use the "GO" command in an upgrade script, for example, when creating stored procedures - the create proc has to be the "first" line in the script.

When I run a script, I get the following error:

Error -2147217900
Incorrect syntax near 'Go'.

Why can't "GO" be used?

Thanks, Rob.

I think I'd have more luck banging my head against a brick wall...

If it's that old, the chances of WebHost4Life upgrading either seems remote (i.e. they don't want to upgrade) but maybe they are about to upgrade.

Rob.