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

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


Please Help Members By Posting Answers For Below Questions

What is the difference between createstatement and preparedstatement?

487


is it important for a database administrator to understand the operating system and file access? : Sql server administration

579


explain different types of cursors? : Sql server database administration

558


How can I tell if sql server is 32 or 64 bit?

493


How can we get count of the number of records in a table?

539






How to read data in a table with "select" statements?

549


What command is used to rename the database?

523


How to recover from sql injection? : sql server security

516


What do you mean by an execution plan? Why is it used? How would you view it?

525


What are the different sql server versions?

512


Explain an incremental backup?

585


Are null values the same as that of zero or a blank space?

570


What are truncate options available in sql server? : sql server database administration

579


can you instantiate a com object by using t-sql? : Sql server database administration

513


create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

498