Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

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
0
fadloun
Asked:
fadloun
  • 2
1 Solution
 
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
 
DhaestCommented:
Implementing SQL Server 2005 Query Notifications in C# Windows Application
http://support.microsoft.com/kb/555893
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now