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 is a unique key constraint?
Which stored procedure will you be running to add a linked server?
How do you create a clustered index?
Can you explain what are commit and rollback in sql?
Does sql server 2000 full-text search support clustering?
What does it mean to normalize a database and why would you do it?
What are partitioned views?
how to count datewise data in sqlserver
4 Answers CarrizalSoft Technologies, IndusInd Bank,
What is referential integrity and how is it achieved?
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
Which are the important points to note when multilanguage data is stored in a table?