What are the OS services that the SQL Server installation adds?
Answers were Sorted based on User's Feedback
Answer / guest
MS SQL SERVER SERVICE, SQL AGENT SERVICE, DTC (Distribution
transac co-ordinator)
Is This Answer Correct ? | 4 Yes | 1 No |
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 |
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 |
Explain system rowset functions?
Why I am getting this error when dropping a database in ms sql server?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is the syntax to execute the sys.dm_db_missing_index_details?
How do I compare two values when one value(data type) is char and the other is an integer?
What is raid, and how it can influence database performance?
How to view existing indexes on an given table using sys.indexes?
How many databases instances are there in sql server 2000?
What is transaction server distributed transaction?
What is a scheduled job or what is a scheduled task?
What are tables in sql server?
What is the purpose of the tempdb database?