Windows Service , SQL Table Listener

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raed Sawalha - 03 Aug 2006 08:02 GMT

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?

Reply to this Message

www.fruitfruit.com - 05 Aug 2006 04:06 GMT

> 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.

Reply to this Message

Rate this thread:

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...