Member Avatar for mstester

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??

Thanks

  • 3 Contributors
  • 3 Replies
  • 171 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by SkinHead
Member Avatar for iamthwee

Bascially take an image of that table before then an image after and compare.

Select * from table x
Member Avatar for mstester

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

Member Avatar for SkinHead

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.