13 important SQL Server interview questions on notification, integration, reporting services

This section will cover the most asked SQL Server interview questions by the interviewer so have a look on the following and do revise it when ever you go for the SQL Server interview

Normally SQL Server interview starts with.....

What are notification services?
What are basic components of Notification services?
Can you explain architecture of Notification Services?
Which are the two XML files needed for notification services?
What are ADF and ACF XML files for?
What is Nscontrols command?
What are the situations you will use “Notification” Services?
What is Integration Services import / export wizard?
What are prime components in Integration Services?
How can we develop a DTS project in Integration Services?
Can you explain how can we make a simple report in reporting services?
How do I specify stored procedures in Reporting Services?
What is the architecture for “Reporting Services “?

So friends answering to above question on notification, integration, reporting services of SQL Server interview questions helped me to clear in front of the interviewer.