In this chapter, you have learned the basics of configuring and using a notification application through using the Notification Services component included in SQL Server 2005. You can further develop the example presented in this chapter by adding historical data treatment, additional delivery channels, and multi-language functionality. SQL Server is a powerful platform for your database installation, providing far more than basic data storage and retrieval. You've seen how SQL Server 2005 handles security, data protection, data transfer, and summary data. You've also seen how SQL server organizes and stores data internally, and you have some understanding of how to optimize data retrieval by modifying the internal storage structure. You've learned how to let your users create their own queries safely through your application interface, how to use remote data sources, and how to access SQL Server via the Internet. You've seen how to use transactions to protect user's data and how to store historical data so that you can back out individual transactions. And now you also know how to use SQL Server 2005's powerful reporting and event notification tools. With a little practice behind you and all this information at your ready reference, you have everything you need to begin crafting your own SQL Server 2005 installation. Chapter 13 Quick Reference To | Do this |
---|
Start a new project for Notification Services | Create an application-specific database, then in SQL Server Management Studio, select New | Project from the File menu and choose SQL Server Scripts as the project template. Add an ADF and an ICF. | Create a Notification Services application foundation | Define the Event class, the Subscription class, the Notification class, and the Provider class. | Deploy a Notification Services application | Create, register, enable, and start a Notification Services instance. | Create a Notification Services instance | In Object Explorer in SQL Server Management Studio, right-click the Notification Services node and choose New Notification Services Instance. | Register a Notification Services instance | In Object Explorer in SQL Server Management Studio, expand the Notification Services node, right-click the instance, and select Tasks | Register from the context menu. | Enable a Notification Services instance | In Object Explorer in SQL Server Management Studio, expand the Notification Services node, right-click the instance, and select Enable from the context menu. | Create a Notification Services instance | In Object Explorer in SQL Server Management Studio, expand the Notification Services node, right-click the instance, and select Start from the context menu. | Update a Notification Services instance | Stop and disable the instance, then in Object Explorer in SQL Server Management Studio, expand the Notification Services node, right-click the instance, and select Update from the context menu. |
|