Answer Posted / varinder sandhu

Dear All,

normally sql sever 2000 supports 16 instance,
this is right.

in 2005 max number is not 50

because sql server 2008 R2 Datacenter supports 25 instance only

i don't think previous version sql server mean 2005 support
50 new 2008 R2 support only 25

it does not make sense.

Ref Article :
http://www.microsoft.com/sqlserver/2008/en/us/R2-editions.aspx

Thanks,
http://varindersandhus.blogspot.com/

How to retrieve field values using mssql_result()?

1186

---

What is merge join?

1124

---

What are pages and extents? : SQL Server Architecture

956

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

892

---

What is an example of a primary key?

911

---

How to use transact-sql statements to access the database engine?

997

---

What is the difference between rank and dense_rank?

990

---

What is the purpose of self join?

914

---

How would you use user_constraints table in DB?

939

---

Difference between 2NF &3NF ?

1029

---

Explain different types of collation sensitivity?

923

---

Explain different types of lock modes in sql server 2000?

879

---

How can you tell if a database object is invalid?

1013

---

What are the advantages of using cte?

951

---

Write a program using SQL queries to find a unique entry in a table.

940

---