Interested to Buy Any Domain ? << Click Here >> for more details...
What are the OS services that the SQL Server installation adds?
- 3 Answers
- 9918 Views
- I also Faced
- E-Mail Answers
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 do I determine how many instances of sql server are installed on a computer?
How to modify existing triggers using "alter trigger"?
What happens if null values are involved in bitwise operations?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What are various limitations of the views?
What is policy based management (pbm)? : sql server database administration
Explain transaction server distributed transaction?
How maney row would be print after join if A table have 100 rows and B table have 50 rows...
What is the difference between lock, block and deadlock? : sql server database administration
Explain alternate key, candidate key and composite key in sql server?
What to check if a User database is locked?
Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?
-
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)
