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 are the benefits of using stored procedures over sql statements?

3 Answers   Ness Technologies,


What is optimistic concurrency?

0 Answers  


Explain trigger and its types?

0 Answers  


how to invoke a trigger on demand? : Sql server database administration

0 Answers  


Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,






What is the log shipping?

0 Answers  


What command do we use to rename a database?

0 Answers  


Why are sql functions used?

0 Answers  


Write the Syntax for Cursors.

2 Answers   CarrizalSoft Technologies, HP,


When multiple after triggers are attached to sql table, how to control the order of execution?

0 Answers  


wat is the main diff between sql server 2000and sql server 2005

6 Answers   Jade Software,


How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

0 Answers  


Categories