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 |
What are the different types of lock modes in sql server 2000?
Explain the architecture of SQL Server?
What is resource governor?
What does it mean to normalize a database and why would you do it?
How will u get 5 years back record?
How you can get the list of largest tables in a database?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is data mart? : sql server analysis services, ssas
Explain an automatic checkpoint
What is bit datatype and what's the information that can be stored inside a bit column?
What is ms sql server index?
What is mean by "fill factor" ? and what is mean by "Index "in sql?
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)