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 connect of datebase with sql express.?

0 Answers   MCN Solutions,

---

What is 1nf normalization form?

0 Answers  

---

Data table as parameter in sql server?

0 Answers  

---

What are a scheduled jobs or what is a scheduled tasks?

0 Answers  

---

What is a livelock?

0 Answers  

---

---

Explain data warehousing in sql server?

0 Answers  

---

What is the difference between for trigger and after trigger?

0 Answers  

---

Explain the etl (extraction, transformation, and loading)?

0 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

Give an example of SQL injection attack ?

0 Answers   HAL,

---

How many types of triggers in sql server?

0 Answers  

---

what is hash nonclustered index

0 Answers  

---