Triggers, DCOM, Stored Procedures and Named pipes for synchronization

[frankle]

Here's the problem:<br>
<br>
I need to set up a mechanism to notify a program which record and field was added, updated, or deleted. The program keeps a memory image of the database. <br>
<br>
One method is to set a trigger to send email to the application. (the application is in VC++). How complicated would it be to receive this email? Would I have to write a Simple MAPI interface or CMC interface? How much work is involved?<br>
<br>
Another method is to interface to SQL Server via DCOM.<br>
<br>
Another method is to set up a stored procedure and use named pipes.<br>
<br>
If anyone understands any of these methods, and can describe a solution, or better, the best solution, it would be appreciated. <br>
<br>
-frank

 

[bitbrain]

Why use MAPI? Can't you execute the VC program from the trigger?

 

[frankle]

I was so much younger when I wrote that message, I can't begin to tell you. &lt;g&gt;<br>
<br>
I wrote an extended stored procedure (.dll) and put a socket communication module in it. Then I made a trigger that executed it. Sounds simple now. <br>
<br>
When I wrote that message I didn't even know how to write a trigger.<br>
<br>
I'm testing the socket code now.<br>
<br>
thanks for your reply.<br>
<br>
-frank