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

Explain stored procedure?

0 Answers  


What is normalization? What number of normalization shapes are there?

0 Answers  


What are the components of sql server service broker?

0 Answers  


What is a covering index?

0 Answers  


What is the difference between seek predicate and predicate?

0 Answers  






What is the difference between cross join and Full outer join?

1 Answers   HP, Standard Bank,


What is sqlcmd?

0 Answers  


what is isolation level at dead lock?

0 Answers   Verizon,


Can sql servers link to other servers?

0 Answers  


What is the difference between local and global temporary tables?

0 Answers  


How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  


What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,


Categories