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

What are the limitations in ssrs on sql server express edition?

175

---

What are database states in ms sql server?

1111

---

Explain the difference between primary keys and foreign keys?

941

---

If a table does not have a unique index, can a cursor be opened on it?

865

---

Explain insert into select statement?

896

---

Do you know concepts and capabilities of sql server?

1003

---

What are dml (data manipulation language) statements in ms sql server?

923

---

What are the different types of columns types constraints in the sql server?

1003

---

What is the meaning of sql server?

934

---

How to replace given values with null using nullif()?

922

---

What does indexation mean?

915

---

Can we insert data into view sql server?

882

---

How many types of functions are there in sql server?

871

---

Which tcp/ip port does the sql server run on? How can it be changed?

988

---

what stored procedure can you use to display the current processes? : Sql server administration

956

---