Solved

Monitor Database Table Changes

Posted on 2009-07-05
3
315 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
  • 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

914 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now