microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Using Triggers as event provider and notification instance state

Subject: Re: Using Triggers as event provider and notification instance state
From: "mickey"
Date: 5 Jul 2005 10:53:05 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
there are probably two ways to handle this depending on your skillset.

all in TSQL - the trigger just logs the event to another table. That
table is swept regularly by a scheduled SQL hosted provider to extract
any outstanding events.

outside TSQL - the trigger drops the event to an XP which stores it on
an MSQ or in a filewatch directory which is handled by another hosted
provider.

Both methods follow the NS architecture of forward and store which
allow components to be switched off and then pick up where they left
off.

hope that help

Kate MBCS

Alert Technologies
http://www.alert-technologies.co.uk
Get your notification services implementation going in minutes not
weeks ......


<Prev in Thread] Current Thread [Next in Thread>