Can you explain the role of each service?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a sub-report?

113


Can you pass expressions to stored procedure parameters?

702


How to write character string constants or literals in ms sql server?

753


how to determine the service pack currently installed on sql server? : Sql server database administration

737


What is the usage of the sign function?

706






What is GUID in sql server?

819


How to find the list of fixed hard drive and free space on server?

782


Does union all remove duplicates?

801


What are difference between Cluster index and Non-Cluster index?

778


What is the difference between count and distinct count?

622


What is query optimization process?

716


It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

747


What samples and sample databases are provided by microsoft?

759


What are the purpose of Normalisation?

796


Why functions are used in sql server?

667