<div>
How does your service know that something has changed ?<br />
<br />
The easiest way to solve such a history change of records, is adding triggers to the table you want to monitor which creates a record in an audit table.
</div>


How does your service know that something has changed ?

The easiest way to solve such a history change of records, is adding triggers to the table you want to monitor which creates a record in an audit table.

<div>
Hi<br />
<br />
As I know I can't do that without a trigger (easiest way ), but I need to be sure from you exchange-experts that it is really impossible , so I can report this impossibility with full confidence <br />
I will check Implementing SQL Server 2005 Query Notifications in C# Windows Application link and come back to you<br />
<br />
regards<br />
<br />

</div>


Hi

As I know I can't do that without a trigger (easiest way ), but I need to be sure from you exchange-experts that it is really impossible , so I can report this impossibility with full confidence
I will check Implementing SQL Server 2005 Query Notifications in C# Windows Application link and come back to you

regards



<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
I am building windows service , this service is supposed to connect to database through ODBC and monitor selected table for changes ( insert,update), I am accessing the database with readonly account , means I can't create or modify anyhing in the database ( create table ,view or trigger) <br />
the table holds more than 200,000 records <br />
Is there a possible techincal way to accomplish that ?<br />
thanks for the help in advance.<br />
regards<br />

</div>
</div>


Hi Experts

I am building windows service , this service is supposed to connect to database through ODBC and monitor selected table for changes ( insert,update), I am accessing the database with readonly account , means I can't create or modify anyhing in the database ( create table ,view or trigger) 
the table holds more than 200,000 records 
Is there a possible techincal way to accomplish that ?
thanks for the help in advance.
regards


Monitor Database Table Changes

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.