Conclusion


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.





Solid Quality Learning - Microsoft SQL Server 2005. Applied Techniques Step by Step
Microsoft SQL Server 2005: Applied Techniques Step by Step (Pro-Step by Step Developer)
ISBN: 0735623163
EAN: 2147483647
Year: 2006
Pages: 115

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net