Is there a MS SQL statement to run an external app?

Question

I want to issue a SQL statement that will run an external batch file. I can locate the file on the SQL server if necessary. This is because the business app I'm using allows me to attach a SQL command to any field, but not an external program to run. Thus I would like to write a SQL statement to run an external program.

Answer 1

You could follow the directions here:
http://www.codeproject.com/database/xyprocedure.asp

Basically you'd just put the sql call to the extended stored procedure in your application.

Answer 2

Use a DTS package to drop a batch file in a predetermined location. Schedule a task in the OS to run the batch file.