Answer / mamatha

A SQL Server 2005 cluster includes two or more physical
servers (called nodes) identically configured. One node is
designated as the active node where a SQL Server 2005
instance is running in production, and the other node is an
inactive node where SQL Server is installed, but not
running. Should the SQL Server 2005 instance on the active
node fail, the inactive node will become the active node and
continue SQL Server 2005 production with minimal downtime.

Answer / sumit

A SQL Server 2005 cluster includes two or more physical
servers (called nodes) identically configured. One node is
designated as the active node where a SQL Server 2005
instance is running in production, and the other node is an
inactive node where SQL Server is installed, but not
running. Should the SQL Server 2005 instance on the active
node fail, the inactive node will become the active node and
continue SQL Server 2005 production with minimal downtime

How to select all columns of all rows from a table with a select statement in ms sql server?

0 Answers  

---

Mention a few common trace flags used with sql server?

0 Answers  

---

How do we return a record set from a Stored Procedure in SQl server 2000?

3 Answers  

---

How to manipulate data from one table to another table ?

0 Answers   MCN Solutions,

---

Define candidate key, alternate key, and composite key.

0 Answers  

---

---

Why foreign key column allowing null values even a parent tables reference key column not having null value..

2 Answers   IBM,

---

Does partitioning improve performance sql server?

0 Answers  

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers  

---

What is the difference between DTS and SSIS?

3 Answers   Allianz,

---

What is the osql utility?

0 Answers  

---

What are “phantom rows”?

0 Answers  

---

What is sql server management studio? : sql server management studio

0 Answers  

---