INF: Enhancements to SQL Server 2000 Notification Services Service Packs (822339)

SUMMARY

SQL Server Notification Services is a platform for developing and deploying applications that generate and send notifications. The notifications can be sent to a wide variety of devices, such as e-mail addresses, cell phone numbers, or Microsoft Windows Messenger clients. Applications built on Notification Services can scale to support thousands to millions of users.

Notification Services 2.0 SP1 is a stand-alone release of Notification Services. Details about the changes in SP1 are in the Readme.txt file, available from the download page.

If you have an existing installation of Notification Services 2.0, you install SP1 side-by-side and then upgrade existing instances. Instructions for upgrading instances are in the Readme.txt file. Detailed instructions are in the "Upgrading Notification Services 2.0 Instances to Notification Services 2.0 SP1" paper, available from the following Microsoft Web page:
Notification Services Technical Resources .

Each installed instance of Notification Services requires a valid SQL Server 2000 Enterprise Edition license. Notification Services software components can be deployed in a single-machine or multiple-machine configuration.

For additional information about obtaining SQL Server 2000 Notification Server service packs, click the article number below to view the article in the Microsoft Knowledge Base:

822348 How to Obtain the Latest SQL Server 2000 Notification Server Service Pack

Microsoft SQL Server 2000 Notification Services 2.0 SP1

Enhancements to Notification Services 2.0 SP1

Setup supports .NET Framework versions 1.0 and 1.1.
NSControl Create adds more indexes, including an index on the events table to improve vacuuming performance and on the notifications table to improve subscription processing performance.
NSDiagnosticFailedNotifications now returns one record per notification delivery failure (except content formatting errors, as documented in item 4.10).
You can configure the standard XSLT content formatter to write plain text. See item 4.11 for more information.
NSControl Create turns on cross-database ownership chaining for instance and application databases. See 4.12 for more information.
If you change the <NotificationBatchSize> or <DigestDelivery> values in the ADF and then update the application using NSControl Update, the Notify function is recompiled to include these changes.
When you add, change, or delete items in the <Protocols> node of a notification class and then update the application, NSControl updates the protocols without re-creating the entire notification class.
The Realtor sample application now runs on case-sensitive collations.
The NSEventFlushBatch<EventClass> stored procedure was updated to avoid a potential deadlock during multithreaded event submission.
Database connection strings were modified to address connection issues on operating systems with a Turkish locale.
On Windows Server 2003, the ASP.NET applications for managing sample application subscriptions run under the NT AUTHORITY\NETWORK SERVICE account. (On other operating systems, they still run under the ASPNET account.)