Microsoft SQL Server 2005 Notification is something which I like the most, believe me it's more then a alarming feature, and truely it is. Whether you like to be aware of when your disk space reaches to a amount or you want to know when a row get updated either in the form of email or report. Surprisingly the information could be in the form of XML which you could later render on the device with the suitable style sheet. For administrators the Management Tool is a choice to configure the Notification Services. Here absolutely we are not forgetting the devlepors who play the most important role in writing up the Notification Contents using SQL and XML.
Your questions are most welcome and will be glad to anwer and to solve them.
Enjoy will come up something more on this.
~Danish Sami