Hi all......another question for ya all :S

Does anyone know of a way to monitor a change to a database,
Basically I need to write some code for my app that can detect a change i.e. table x has been modified in someway or table y has been created etc?

Anyone help me with this??


10 Years
Discussion Span
Last Post by SkinHead

How would I do that though?
Also would that not be a huge overhead if your monitoring the entire db?


First & Foremost, Why On Earth Would You Want To Monitor Changes (Inserts, Updates, Deletes, Create Tables !) In The WHOLE Database ?

What Programming Environment Are You Writing Your Application In ? VB6 / VB.NET /C# etc

If The RDMS Is Oracle Or SQL Server 2005 (Standard) I Believe You Can Register Queries Within The Database To Be Posted Notification Events. Try Google "Database Notification Events" !!!!

FYI : I've Done It Using SQL Server 2000, Database Triggers, Extended Stored Procedures & A VB6 Application.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.