What are the OS services that the SQL Server installation adds?
- 3 Answers
- 9116 Views
- I also Faced
- E-Mail Answers
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 are the various editions of sql server 2017 that are available in the market?
What is spid in sql server profiler?
What is history table in sql server?
What is a field name?
Explain the disadvantages/limitation of the cursor?
We need to perform what steps in the following order to work with a cursor?
What is built-in function?
What is cursors? And what are the different types of cursor?
How many databases can we create in a single server?
What is user-defined multi-statement table-valued function?
How to fetch the next row from a cursor with a "fetch" statement?
What is bit data type?
what is the information that can be stored inside a bit column? : Sql server database administration
What are different replication agents and what's their purpose? : sql server replication
What is table level trigger?
