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

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

1024

---

Can the “if update (colname)” statement be used in a delete trigger?

1032

---

why would you call update statistics? : Sql server database administration

1153

---

how many type of indexing in database?

1017

---

How to include date and time values in sql statements?

1137

---

Define msdb database?

1074

---

Are semicolons required at the end of sql statements in sql server 2005?

1035

---

Explain raiserror in sql server?

1074

---

How can you stop stored procedures from recompiling?

946

---

what is create database syntax? : Sql server database administration

1155

---

What is a cache in ssrs?

138

---

What sql server means?

1002

---

Does the order of columns in update statements matter?

954

---

What are the characteristics of modern DBMS?

1137

---

How to drop an existing user defined function in ms sql server?

1062

---