Check out xp_cmdshell in Books Online.

> -----Original Message-----
> From: Andrews, Daryl [SMTP:[Email Address Removed] Sent: Thursday, October 30, 2003 1:41 AM
> To: LazyDBA.com Discussion
> Subject: Converting Oracle SQL Scripts to MSSQL2000
>
> 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
>
>
>
Euler Hermes is the world's premier credit insurer, offering solutions for
the management of trade receivables, from credit insurance and factoring to
bonding and guarantees.
-------------------------------------
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient or have received this e-mail in error, notify
the sender immediately and destroy this e-mail. Any unauthorised use,
copying, disclosure or distribution of the contents of this e-mail is
strictly forbidden and may be unlawful.

Read our full e-mail disclaimer statement and monitoring policy
(http://www.eulerhermes.com/disclaim/email.cfm) before taking any action
based on the contents of this e-mail.


MS Sql Server LazyDBA home page