Solved

Monitor Database Table Changes

Posted on 2009-07-05
3
319 Views
Last Modified: 2013-11-26
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
Comment
Question by:fadloun
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 53

Expert Comment

by:Dhaest
ID: 24782976
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
 
LVL 53

Accepted Solution

by:
Dhaest earned 500 total points
ID: 24783314
Implementing SQL Server 2005 Query Notifications in C# Windows Application
http://support.microsoft.com/kb/555893
0
 
LVL 5

Author Comment

by:fadloun
ID: 24783379
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

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A basic question.. “What is the Garbage Collector?” The usual answer given back: “Garbage collector is a background thread run by the CLR for freeing up the memory space used by the objects which are no longer used by the program.” I wondered …
In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question