I'm attempting to convert an Oracle database to SQL Server 2000. Some of
the daily processing scripts rely heavily on the HOST command. In Oracle
SQL scripting you can use this command to invoke programs also on that
machine anywhere in the SQL script without having to exit, run your other
program, then invoke another script. A sample of this phrasing in an Oracle
script is

HOST c:\MyFolder\MyProgram.exe.

Does anyone know of a way to handle this with MSSQL scripts?

Has anyone found a book that you can recommend that is a good reference for
converting Oracle scripts to MSSQL?

Thanks!

Daryl

MS Sql Server LazyDBA home page