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
How to generate create function script on an existing function?
What are triggers? How do you invoke a trigger on demand?
How to get the number of affected rows?
What are user defined functions in ms sql server?
What is the difference between Normalization and De-normalization?
What is Cross Join and in which scenario do we use Cross Join?
What is query and its types?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
Explain left outer join and right outer join?
Tell me what are the advantages of using stored procedures?
What is statement level trigger?
How we can refresh the view?
Explain “@@rowcount” and “@@error” in sql server?
Please illustrate physical database architecture? : SQL Server Architecture
Can the query output be sorted by multiple columns in ms sql server?