Re: Trigger functionality without trigger

From: Val Mazur (group51a_at_hotmail.com)
Date: 06/30/04 

Date: Tue, 29 Jun 2004 21:43:20 -0400

Hi,

Database or provider does not notify about the changes, so there is no
direct way to get them. Using triggers probably the easiest solution in this
case. If you do not do this, then you would need to implement some sort of a
time stamp field in a monitoring table and query it for the changes once in
a while. It could be more expensive from performance point of view. 

-- 
Val Mazur
Microsoft MVP
"Matt" <Matt@discussions.microsoft.com> wrote in message 
news:77A350DF-C2F0-4CE7-A8FA-996C695AD2FC@microsoft.com...
> Hi all,
>
> What I am trying to do may be a bit weird but please bear with me!
>
> I need to find out when data is changed in a table and perform some action 
> based on this.  The problem is that I cannot set up a trigger on this 
> table as I am not allowed to modify the DB at all.  Everything I need to 
> do has to be through .net code.
>
> If anyone can help at all or even point me in the right direction it would 
> be greatly appreciated.
>
> Thanks.