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 benefits of using stored procedures over sql statements?
What is optimistic concurrency?
Explain trigger and its types?
how to invoke a trigger on demand? : Sql server database administration
Differences between functions and stored procedures?
8 Answers 247Customer, Accenture,
What is the log shipping?
What command do we use to rename a database?
Why are sql functions used?
Write the Syntax for Cursors.
2 Answers CarrizalSoft Technologies, HP,
When multiple after triggers are attached to sql table, how to control the order of execution?
wat is the main diff between sql server 2000and sql server 2005
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?