Hello David,
quote:
Ideally I would like to be able to do something along the lines ofecho off
cls
osql -USA -PPassword -iInstall01.sql -oInstall01.Err
if ErrorLevel==0
osql -USA -PPassword -iInstall01.sql -oInstall01.Err
etc
In an ideal world I would like something like the install routine that is used to apply SQL Server service packs. The one that says "applying n of m".
not sure it this is a good solution for you. But I remember Visual Studio 6 comes along with a programmable version of Install Shield Wizard. I haven't tried this and it might be overkill for what you want. But I guess it can do want you need.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]