-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|