Answer / trived

normally sql sever 2000 16 instance possible
in 2005 50 instance possible

Answer / setaceo

In Workgroup Edition : 16 Instances
In Enterprise/Developer/Standard Editions : 50 Instances

Answer / neel

Establishes the maximum number of SQL Server 2008 instances
that can be created on a server. Enterprise Edition
supports up to 50 instances on a server, Compact Edition
only supports one instance, and all the other editions
support up to 16 instances.

Answer / 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 do I get to sql server configuration manager?

0 Answers  

---

What is Self Join?

4 Answers  

---

How will you decide the active and passive nodes?

0 Answers  

---

How do I make a resultset scrollable?

0 Answers  

---

What is the difference between push and pull subscription? : sql server replication

0 Answers  

---

How would you use user_constraints table in DB?

0 Answers   Wipro,

---

Explain syntax for disabling triggers?

0 Answers  

---

Explain trigger and its types?

0 Answers  

---

What is database replication? What are the different types of replication you can set up in sql server?

0 Answers  

---

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

Detail about query optimizer?

0 Answers  

---