Re: how to call external exe from Database Trigger

Hi,

I wouldnt do any external things like sending mails, executing a program etc in a trigger though it happen synchronously, that means the transaction wil block you data during the execution, better do that in a job with falgging some table that this job has to be done.

But if you really want t, you can call the app with this here:

(...TriggerCode...)
IF (SomeCondition)
BEGIN
   EXEC XP_CMDSHELL 'C:\someFolder\SomeCommand.exe' END HTH, jens Suessmeyer.

---

http://www.sqlserver2005.de
---
Received on Wed Mar 29 2006 - 05:59:04 CST