SQL Server 2000 Notification Services makes it easy to develop and deploy applications that generate and send personalized notifications to wired and wireless devices. Notification Services scans input events from a wide variety of sources, matches these events against a user’s subscriptions, generates and formats personalized notifications, and delivers the notifications to the subscriber’s preferred device.
Notification Services consists of a simple declarative programming framework for describing the notification application and an efficient, highly-scalable server that runs the application. Notification Services enables you to build an application that scales to millions of users in days.
Article Link.