Building Your Own Notification Application
In this section, we'll build a Notification Services application from scratch. The app we'll build will be a Bug Notification Service (BNS)—it will notify subscribers when new product bugs are entered into a SQL Server table and when changes are made to them. Events will be generated via a trigger on the Bugs table in a custom database (outside of Notification Services), and notifications will be delivered over SMTP. We'll build all the pieces of the application, including the subscription management app. I'm assuming for the purposes of this exercise that you have SQL Server, Notification Services, and an SMTP server (the Windows NT product family ships with an SMTP server) all installed on the same ...
Get Guru's Guide to SQL Server Architecture and Internals, The now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
