Answer Posted / 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.

Why do we use stored procedures in sql server?

939

---

Explain the concepts and capabilities of sql server?

976

---

Explain time data type in sal server 2008?

923

---

Do you know what is lock escalation?

1012

---

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1903

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1268

---

what are constraints? : Sql server database administration

1056

---

Can we use pragma autonomous_transaction in trigger?

962

---

How can delete duplicate records in cte in sql server?

964

---

How to check status of stored procedure in sql server?

988

---

What is shrink log file?

897

---

How to copy data from one table to another table?

996

---

What is truncate table?

939

---

When we should use @@error?

966

---

Explain about SQLOS?

1010

---