Monitor Database Table Changes

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
LVL 5
fadlounAsked:
Who is Participating?
 
DhaestConnect With a Mentor Commented:
Implementing SQL Server 2005 Query Notifications in C# Windows Application
http://support.microsoft.com/kb/555893
0
 
DhaestCommented:
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.
0
 
fadlounAuthor Commented:
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

0
All Courses

From novice to tech pro — start learning today.