471,056 Members | 1,646 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,056 software developers and data experts.

Windows Service , SQL Table Listener

I;m developing a windows service using VC++.NET (unmanaged) that will catch
changes on SQL Table to build XML file of new added, updated records and send
them to specific destination.

My Question What is the mechnisim to make the service know the changes on
the table?
Aug 3 '06 #1
1 2205
Raed Sawalha wrote:
I;m developing a windows service using VC++.NET (unmanaged) that will catch
changes on SQL Table to build XML file of new added, updated records and send
them to specific destination.

My Question What is the mechnisim to make the service know the changes on
the table?
Create a trigger in your database on that table. You can create extended
stored procedure to forward updates, or just copy modified data to
another table, and your program periodically query it, or simply add a
timestamp field to your table.
Aug 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Wayne Happ | last post: by
3 posts views Thread by Craig Thompson | last post: by
5 posts views Thread by vinoth | last post: by
7 posts views Thread by Giulio Petrucci | last post: by
4 posts views Thread by cmgarcia17 | last post: by
3 posts views Thread by jwpaco | last post: by
4 posts views Thread by pbd22 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.