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
What is the difference between createstatement and preparedstatement?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
explain different types of cursors? : Sql server database administration
How can I tell if sql server is 32 or 64 bit?
How can we get count of the number of records in a table?
How to read data in a table with "select" statements?
What command is used to rename the database?
How to recover from sql injection? : sql server security
What do you mean by an execution plan? Why is it used? How would you view it?
What are the different sql server versions?
Explain an incremental backup?
Are null values the same as that of zero or a blank space?
What are truncate options available in sql server? : sql server database administration
can you instantiate a com object by using t-sql? : Sql server database administration
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration