O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required