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

When would you use a before or after trigger?

902

---

What are the steps you should follow to start sql server in single-user mode?

891

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1914

---

How can I get data from a database on another server?

979

---

Explain what is the main purpose of having conversation group?

925

---

Which are the important points to note when multilanguage data is stored in a table?

984

---

How can I check that whether automatic statistic update is enabled or not?

1034

---

Do you know the cursor types?

1150

---

How does a profiler work?

915

---

What are the advantages of paper records?

956

---

What are entities and relationships?

962

---

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

155

---

Is null in sql server?

978

---

How many types of keys are there?

1020

---

What do you mean by collation recursive stored procedure?

1050

---