Answer / guest

MS SQL SERVER SERVICE, SQL AGENT SERVICE, DTC (Distribution
transac co-ordinator)

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

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.

Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

What is dbcc command in sql server?

0 Answers  

---

Give me a SQL Query to find out the second largest company?

0 Answers   Ernst Young,

---

Is SET a SQL Keyword?

4 Answers   BitWise,

---

What are four major operators that can be used to combine conditions on a where clause?

0 Answers  

---

How to delete an attribute from the emp table

4 Answers  

---

What is full form of XP ?

42 Answers   Cap Gemini, Infosys, Microsoft, Oracle, Reliance,

---

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

---

What is buffer cash and log cache in sql server?

0 Answers  

---

What are the purposes and advantages stored procedure?

0 Answers  

---