Hi Bill,

I did this type of thing many, many years ago, running scripts with a "DBA" app I wrote specifically designed for updating our database schemas and stored procs. In fact, the first one was written in VFP, later ported to .NET ... and I use SMO.

I didn't read the link that Naomi provided, but if you get stuck, let me know ...

~~Bonnie





>Thanks, Naomi.
>
>They seem to be making a string out of the script and executing it as a command.
>That's what I had in mind, but they have some good tips in there that will save some hunting around.
>
>
>>>See a first sample I googled (bottom of the thread) here
>http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/43e8bc3a-1132-453b-b950-09427e970f31
>
>You need to google on 'SMO run SQL Script .NET'
>
>Another link
>http://mkdot.net/blogs/boban/archive/2008/08/07/run-a-sql-script-files-in-c.aspx