Help with Executing a .SQL file

[Ryan Ternier]

I'm having an issue with this.

I have 2 SQL files over 3000 lines long each. I need to run these files
when one of our sales people presses a button.

I can't save them as a Stored Procedure because SQL 2000 complains too much.

The Files work perfectly.

One is a DB Reset file, the other is a DB Init file where it initializes the
DB with all data in it.


I've tried loading these up in a stream reader, but .NET throws a bunch of
crap in the file - which I can take out - but it looses it's formating.

Is there a way to easily do this? Or will I have to recursively go through
each node in the file until I hit GO, then execute that?

 

[Bob Barrows [MVP]]

I'm having an issue with this.

I have 2 SQL files over 3000 lines long each. I need to run these
files when one of our sales people presses a button.

I can't save them as a Stored Procedure because SQL 2000 complains
too much.

The Files work perfectly.

One is a DB Reset file, the other is a DB Init file where it
initializes the DB with all data in it.


I've tried loading these up in a stream reader, but .NET throws a
bunch of crap in the file - which I can take out - but it looses it's
formating.

Is there a way to easily do this? Or will I have to recursively go
through each node in the file until I hit GO, then execute that?

How about shelling to osql?

Or using xp_cmdshell?

Of course, you could break them up into multiple stored procedures ...

 

[Tim Cartwright]

not asp.net, but this is how you could go about it.
http://www.sqlteam.com/item.asp?ItemID=11123 you would use sqldmo. I am
unsure what the new library would be for the 2k5 db, but for 2k and below
you used sqldmo to accomplish what you wanted.