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/

What is Command line parameters in PLSQL.?

1110

---

How do I find information about the install locations for the various instances running on a computer?

1063

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

933

---

How will you find out if there are expensive SQL statements running or not?

1001

---

What are relationships and mention different types of relationships in the dbms

946

---

How to create new databases with "create database" statements?

999

---

What are the transaction properties?

995

---

What is normalization 1nf 2nf 3nf?

1042

---

What Is Rdbms?

1132

---

How does the report manager work in SSRS?

148

---

Can we delete data from a view?

912

---

What is GUID in sql server?

1145

---

Does partitioning help performance?

918

---

What methods do you follow to protect from sql injection attack?

1002

---

What the different components of Replication and what is their use?

1054

---