Hi Daryl,

In SQL Server the stored procedure master..xpcmdshell should help, unless
its execution has been disabled by the dba. A sample syntax would be:

master..xpcmdshell "c:\MyFolder\MyProgram.exe"

I don't think that this can return results back to the script though.

Hope this helps.

Regards,

Suresh




"Andrews, Daryl"
<[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
com> cc:
Subject: Converting Oracle SQL Scripts to MSSQL2000
30/10/2003 12:41





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