I have a script for my database that works wonderfully in SQL Manager Express.

I'd like to feed it to sqlclient.executenonquery. But as a mimimum all those
GO statements get in the way.

Is there any way of using the generated script short of massaging it by hand?

--
Regards,
Al Christoph
Senior Consultant
Three Bears Software, LLC
just right software @ just right prices @ 3bears.biz
Microsoft Certified Partner (ISV)
Coming soon: Windows Mail for Vista.

The GO is a batch separator used by SSMS to determine when to send a command
to the server. If your SQL Client program sends a batch fro every GO
statement (and doesn't include the GO) it should work the same as the SSMS
script.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Al Christoph" <AlFrom3BearsSoftware (AT) newsgroups (DOT) nospam> wrote