Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     

SQL Server interview questions: - What do you mean by architecture of Notification Services?

This is the SQL Server interview questions which more of Database administrator (DBA) oriented. Have a look before going for interview. So one can start answering this question as follows.

Detail sections in SQL notification services:-

Notification Service application: - It’s a simple user application which will be used to add subscription to the subscription database.

Event providers: - All events reside in Event providers. There are two event providers which are provided by default “File System watcher” and “SQL Server event provider”. “File System watcher” detects changes in operating system files. “SQL Server event provider” watches for SQL Server or analysis service database for change. You can also plug in custom event providers. When event providers find any change in database, they send the event in “Event” table.

Generator: - Generator checks the event database, when it finds any event it tries to match with the subscription and sends it to the notification database. So generator in short is the decision maker between the subscribers and the events.

Distributor: - Distributor continuously pools the “Notification” database for any “Notification’s” to be processed. If the distributor finds any entry, it retrieves it and formats it so that it can be delivered to the end recipient. Formatting is normally done using “XML” and “XSLT” for rendering purpose.

After the formatting is done, it is then pushed to the “distribution providers”. They are nothing but medium of delivery. There are three built-in providers:-

  • SMTP provider
  • File provider
  • HTTP provider

Figure: - Detail architecture of SQL notification services.

See the following video on calling a stored procedure using LINQ: -

Click for more SQL Server interview questions


Visit for more author’s blog on SQL Server interview questions

Share this article   |    Print    |    Article read by 4165 times
Shivprasad koirala Koirala
I am a Microsoft MVP for ASP/ASP.NET and currently a CEO of a small E-learning company in India. We are very much active in making training videos , writing books and corporate trainings. Do visit my site for .NET, C# , design pattern , WCF , Silverlight , LINQ , ASP.NET , ADO.NET , Sharepoint , UML , SQL Server training and Interview questions and answers
Related Articles: No related article
Related Interview Questions: