Notification Services uses Event Providers. There will be File Watcher Provider, SQL Server Event Provider, Analysis Services Event Provider, And general interfaces.
The SQL Server Event Provider uses it's own stored procedures (ie: NSEventWrite) More generally though, SQL Server will have trigger-type objects called Events created with CREATE EVENT NOTIFICATION I'm assuming for use outside of Notification Services. CC 1A 5B 94 D0 75 09 B4 USA USA USA USA USA http://hp6000.vinnychi.com/vince Did you think that I was gonna give it up to you? > -----Original Message----- > From: Unmoderated discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of > Philip Nelson > Sent: Friday, October 01, 2004 6:44 AM > To: [EMAIL PROTECTED] > Subject: Re: [ADVANCED-DOTNET] Database Notification > > --- Ben Kloosterman <[EMAIL PROTECTED]> wrote: > > > The most common way is to get a service to poll the DB , > complicating > > the DB side with triggers etc is something better avoided IMHO . > > But you can use triggers to aid the polling by having them do > something very > simple, fast and reliable, such as dropping an "event" in a > polled table. At > very high transaction rates, it could add to the list of > issues to deal with, > but pretty much any mechanism is going to do that and this > approach might be > easier than trying to watch for changes in a table. > > I wonder specifically what notification services does to > accomplish this? > > ===== > Philip - http://blogs.xcskiwinn.org/panmanphil > "There's a difference between righteous anger and just being > crabby" - Barbara > > =================================== > This list is hosted by DevelopMentor. http://www.develop.com > Some .NET courses you may be interested in: > > Essential .NET: building applications and components with CSharp > August 30 - September 3, in Los Angeles > http://www.develop.com/courses/edotnet > > View archives and manage your subscription(s) at > http://discuss.develop.com > =================================== This list is hosted by DevelopMentorŪ http://www.develop.com Some .NET courses you may be interested in: Essential .NET: building applications and components with CSharp August 30 - September 3, in Los Angeles http://www.develop.com/courses/edotnet View archives and manage your subscription(s) at http://discuss.develop.com
