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 use of except clause?

739


What is raiseerror? What is raiseerror?

739


Write a query for primary key constraint with identity key word?

660


What is the use of toad or sqldbx.?

815


what is the difference between Tabular and Matrix report?

132






Write the queries for commands like Create Table, Delete table, Drop Table etc.

703


Can truncate be rolled back?

619


Distinguish between nested subquery and correlated subquery?

637


What is a schema in ms sql server 2005?

651


Can you get second highest salary from the table?

640


What is log shipping?

644


Write a sql query to delete duplicate records from a table called table1

693


What are the main differences between #temp tables and @table variables and which one is preferred?

639


What is the downside of using udf?

658


What is sql server locking?

622