What are the OS services that the SQL Server installation adds?

Answers were Sorted based on User's Feedback



What are the OS services that the SQL Server installation adds?..

Answer / guest

MS SQL SERVER SERVICE, SQL AGENT SERVICE, DTC (Distribution
transac co-ordinator)

Is This Answer Correct ?    4 Yes 1 No

What are the OS services that the SQL Server installation adds?..

Answer / maheswar reddy s

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

What are the OS services that the SQL Server installation adds?..

Answer / rajender.m

sqlserver:Provides storage, processing and controlled access
of data and rapid transaction processing.

sqlserverAgent:Executes jobs, monitors SQL Server, and fires
alerts, and allows automation of some administrative tasks.

sqlserver analytical services:Supplies online analytical
processing (OLAP) and data mining functionality for business
intelligence

sqlserver browser:Provides SQL Server connection information
to client computers.

sqlserver fulltext search :Quickly creates full-text indexes
on content and properties of structured and semi-structured
data to allow fast linguistic searches on this data.

sqlserver integration services:Provides management support
for SSIS package storage and execution.

sqlserver Reporting services:Manages, executes, renders,
schedules and delivers reports.

sqlserver VSS writer:Provides the interface to
backup/restore Microsoft SQL server through the Windows VSS
infrastructure.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is a unique key constraint?

0 Answers  


Which stored procedure will you be running to add a linked server?

1 Answers  


How do you create a clustered index?

0 Answers  


Can you explain what are commit and rollback in sql?

0 Answers  


Does sql server 2000 full-text search support clustering?

0 Answers  






What does it mean to normalize a database and why would you do it?

0 Answers  


What are partitioned views?

0 Answers  


how to count datewise data in sqlserver

4 Answers   CarrizalSoft Technologies, IndusInd Bank,


What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,


How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 Answers  


What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

0 Answers  


Which are the important points to note when multilanguage data is stored in a table?

0 Answers  


Categories