You don't have to call another application, you can do it from SQL, i.e.,
xp_cmdshell. But you could use sp_oacreate, or even MSMQ. But remember, if
the deletion gets hung up, by maybe a concurrent use issue, don't let your
trigger and your user hold on waiting. That's why I'd probably go for MSMQ
if the frequency is high.
Quote:> here's what I'd like to do --- but don't know if I can do - or how
> I want to write a trigger that monitors a table, based on the information
on the table (an event) I want the trigger to call an external (non SQL)
application - say one that deletes a file from the directory.....
> can this be done? Any examples?