"Jon Rowlan" <jon.rowlan@sads.com> wrote in message
news:O61bdrmqHHA.4132@TK2MSFTNGP05.phx.gbl...
> Is it possible to trigger a .EXE program to run on a Row insertion ...
>
> I want to run an .EXE program whenever a new row is inserted to create a
> directory somewhere on the server.
>
> I know that there are triggers that I can use but these seem to be to
> execute SQL statements ...
>
> many thanks all,
>
> jON
>
>

"Russell Fields" <russellfields@nomail.com> wrote in message
news:u8$vVXpqHHA.4740@TK2MSFTNGP02.phx.gbl...
> Jon,
>
> In your trigger, provided that it is enabled for non-sysadmin use, you can
> use the xp_cmdshell procedure to issue an operating system command line
> statement. This will, of course, cause a small delay in the completion of
> your insert statement. (But xp_cmdshell has security issues.)
>
> If you can stand a minute or two of asynchronous delay you might do
> something like the following.
> 1. Create a SQL Agent job to run the EXE.
> 2. Post enough data in the inserted table or in another table if necessary
> to describe with directories still need to be created.
> 3. From your trigger issue an sp_start_job 'jobname'
>
> This will run asynchronously from the trigger, allowing the trigger to
> complete. If you are using SQL Server 2005 you can grant the job the
> needed security context using a SQL Agent proxy account.
>
> RLF
> "Jon Rowlan" <jon.rowlan@sads.com> wrote in message
> news:O61bdrmqHHA.4132@TK2MSFTNGP05.phx.gbl...
>> Is it possible to trigger a .EXE program to run on a Row insertion ...
>>
>> I want to run an .EXE program whenever a new row is inserted to create a
>> directory somewhere on the server.
>>
>> I know that there are triggers that I can use but these seem to be to
>> execute SQL statements ...
>>
>> many thanks all,
>>
>> jON
>>
>>
>
>