I need to create a trigger on a table to run another process that will take
the new row and process/filter it, and then transport it to various other
destinations (using ftp, etc). Writing the trigger is pretty easy, but I'm
wondering, what is now considered to be the "best" way to interface to
another process using dotnet (and C#). Here are my choices as I understand
1) Write a COM object and have the trigger instantiate and invoke it.
2) Write an extended stored procedure to be called by the trigger.
3) Write an external program that ...