1 :: How does Notification Services Work?

Subscription data can be added using (SMO) Subscription Management Objects to Notification Services application. Events get populated to events table with the help of Event providers. When events are populated into events table, the generator wakes up and starts processing rules that are attached with subscriptions. The generator checks to see if any events match them. The generator starts creating notifications and fills the Notifications table, if matches are found. When notifications arrive in Notifications table, the distributor wakes up and starts processing each notification, formats it and delivers them using specified channel.

2 :: What are Notification services?

Notification Services are services which send notifications to the interested entities based on what they would like be notified on.

It is one of the features of the SQL Server.

3 :: Explain architecture of SQL Server Notification services?

Notification Services consists four components

Subscription
Subscription data can be added using (SMO) Subscription Management Objects to Notification Services application.

Events
Events get populated to events table with the help of Event providers.

Generator
When events are populated into events table, the generator wakes up and starts processing rules that are attached with subscriptions. The generator checks to see if any events match them. The generator starts creating notifications and fills the Notifications table, if matches are found.

Delivery (notifications)
When notifications arrive in Notifications table, the distributor wakes up and starts processing each notification, formats it and delivers them using specified channel

4 :: What are the basic components of Notification services?

The following terms are the components of Notification Service:

Event: an action that occurred affecting the specified data.

Subscriber: an entity that wants being notified on occurrence of an event.

Subscription: an act by which subscriber describes when and what he wants to be notified as.

Notification: a channel of communication

5 :: What are the restrictions applicable while creating views?

Views can be created referencing tables and views only in the current database.
A view name must not be the same as any table owned by that user.
You can build views on other views and on procedures that reference views.
Rules or DEFAULT definitions can't be associated with views.
Only INSTEAD OF triggers can be associated with views.
The query that defines the view cannot include the ORDER BY, COMPUTE, or COMPUTE BY clauses or the INTO keyword.
You cannot define full-text index definitions for views.
You cannot create temporary views
You cannot create views on temporary tables.