Re: Trigger functionality without trigger
From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 06/28/04
- Next message: William \(Bill\) Vaughn: "Re: How can I get my parameters collection after a SP call?"
- Previous message: Nate Clark: "Re: Access DB grows too fast."
- In reply to: Matt: "Trigger functionality without trigger"
- Next in thread: Val Mazur: "Re: Trigger functionality without trigger"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 28 Jun 2004 10:48:21 -0700
Without a trigger, all you can do is poll. That is, write a query that tests
to see if the data has changed. This can be pretty tough though and would
add quite a bit of overhead to the system.
-- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ "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.
- Next message: William \(Bill\) Vaughn: "Re: How can I get my parameters collection after a SP call?"
- Previous message: Nate Clark: "Re: Access DB grows too fast."
- In reply to: Matt: "Trigger functionality without trigger"
- Next in thread: Val Mazur: "Re: Trigger functionality without trigger"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
