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 |
How many database files are there in sql server 2000?what are they?
Can we rewrite subqueries into simple select statements or with joins? Example?
What is the difference between dataadapter and datareader?
what is package and it uses and how can u call a package
How do you trace the traffic hitting a sql server?
Explain what is it unwise to create wide clustered index keys?
Is the primary key column of a table an index in ms sql server?
What is dirty page?
What are the components of sql server service broker?
What is the difference between Clustered and Non-Clustered Index?
What is a data collection table?
How to enable/disable indexes?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)