Windows Service , SQL Table Listener

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Raed said:
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?
Click to expand...
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.
 
Back
Top