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 is the server name for sql management studio?

949

---

How to create a user to access a database in ms sql server using "create user" statements?

913

---

whats the maximum size of view state??

2148

---

What are the essential components of sql server service broker?

966

---

How to list all field names in the result set using mssql_field_name()?

870

---

What is merge join?

1127

---

ow to bring suspect mode datbase online from scratch

1763

---

What happens when converting big values to integers?

959

---

What is log shipping?

912

---

How many types of subqueries are there in sql server?

937

---

When you should use a low fill factor?

944

---

How many types of local tables are there in sql server?

889

---

What is a database in ms sql server?

995

---

How to delete an existing row with delete statements in ms sql server?

1023

---

What command is used to delete a table from the database in the sql server and how?

1043

---