Can you explain the role of each service?



Can you explain the role of each service?..

Answer / guest

SQL SERVER - is for running the databases SQL AGENT - is for
automation such as Jobs, DB Maintanance, Backups DTC - Is
for linking and connecting to other SQL Servers

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to turn on the mssql api module in php?

0 Answers  


What is an example of a foreign key?

0 Answers  


How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

10 Answers   Cognizant, Infosys,


how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers   Accenture, IBM, Marlabs,


What is a trigger and its types?

0 Answers  






How to use column default values in insert statements in ms sql server?

0 Answers  


How to delete database objects with "drop" statements in ms sql server?

0 Answers  


What will happen if a column containing char type data is changed to the nchar data type?

0 Answers  


What are the steps you will take to improve the performance of a poor performing query?

0 Answers  


SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  


Explain “not null constraint” in sql server?

0 Answers  


Explain few of the new features of sql server 2008 management studio

0 Answers  


Categories