Re: Event Handlers on lists

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Lionel Moyal (lionelm_at_intervate.RemoveThis.com)
Date: 07/20/04 

Date: Tue, 20 Jul 2004 09:58:28 +0200

I thought about that option, however it's not particularly pretty!
In the absence of better ideas, do you have any more information as to which
tables to add the trigger to and what data to look for specifically?

Also, how do Sharepoint Alerts get triggered? Surely they are generated from
some kind of event on the list itself? Does this happen at the database
level or is there some other mechanism that can be used to listen for these
events?

Regards
Lionel

"Joachim von Seydewitz" <Joachim.vonseydewitz_AT_ITVTNOSPAM.de> wrote in
message news:e2FJTZXbEHA.2972@TK2MSFTNGP12.phx.gbl...
> Hi
>
> > For example, I would like to trigger some code to execute when an item
is
> > added to a custom list, and similarly on a survey.
> >
> > Is there any way to acheive this?
>
> Yes, there is a way to do that - but not supported. You can add a trigger
to
> your database which run a script, which execute your code.
>
> Greetings
> Joachim
>
> >
> > Thank you
> > Regards
> > Lionel Moyal
> > lionelm@intervate.com.removethis
> >
> >
>
>

Relevant Pages

  • Re: Best Practice - xp_cmdshell question
    ... execute from the trigger and use an alternate method. ... objects in an sa-owned database. ... >> without direct user execute permissions by changing your user database ...
    (microsoft.public.sqlserver.security)
  • Re: Error 2950 - Reserved Error on form refresh/requery
    ... and I can't leave the client with an unusable database while I try to ... The requery is on the form (so the data displayed in the sub-forms refreshes ... The triggering event is a listbox after update that does 2 things only: ... can trigger others, and so the problem may occur only when a specific ...
    (microsoft.public.access.formscoding)
  • Re: Help with INSERT TRIGGER - fails with error.
    ... You didn't declare any PRIMARY KEY in this database. ... In an INSERT trigger, ... but I can't get it to work because it references ntext fields. ...
    (comp.databases.ms-sqlserver)
  • Re: Lookup Tables, the right way?
    ... model is comes in un-learning what you know about file systems. ... The users might not all have the same database access rights ... This rule would be enforce by a REFERENCES ... with a trigger that you can do with DRI and more. ...
    (comp.databases.theory)
  • Re: Using one table vs. many
    ... model is comes in un-learning what you know about file systems. ... The users might not all have the same database access rights ... This rule would be enforce by a REFERENCES ... with a trigger that you can do with DRI and more. ...
    (comp.databases)