trigger or "register callback"??

Hi, I am currently using merge replication between 2 sites (A and B).

I need some mechanism (eg. trigger) to inform my VC++ application at Site A for new inserted records or updates from Site B, and vice versa.

I tried to use trigger. However, found that I could only print some messages in SQL query analyzer. I have not found the way for SQL server to "talk" to my VC++ application about which are the newly added merged records, or the updates from the other site.

May be there are other features in SQL that I could use, in stead of trigger? Or there is this feature in SQL that I can register in the beginning, can when new records or updates from other site comes in, I can be informed which are the records, and then notify my VC++ application.

Thanks in advance.

Look into BOL for SP_OAMethod. you can create DLL and register it on the server and call the DLL from sp_OAmethod