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 purpose does the model database serve? : Sql server database administration
How do I completely remove sql server instance?
What is Self Join?
sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??
What is a partition function in sql server?
What are the differences between user defined functions and stored procedures?
Explain about Views?
Does sql server use java?
What is the difference between distinct clause and group by clause?
Call by value and call by reference in procedure and function, with NOCOPY.
What do we have to check in database testing?
What is a view and what are its advantages?
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)