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/

What are the advantages of using sql server over ms access or why should one use sql instead of ms access

2 Answers   CMS, Impetus,

---

List the different index configurations possible for a table?

0 Answers  

---

How do I install only the client tools of sql server 2000?

0 Answers  

---

When would you prefer to have a minimum number of indexes?

0 Answers  

---

What is the minimum recommended amount of ram for sql server 2012 enterprise?

0 Answers  

---

Explain about builtinadministrator?

0 Answers  

---

What is the system function to get the current user's user id?

2 Answers   HCL,

---

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,

---

In which year relase the 7.0& 2000 & 2005?

1 Answers  

---

Diffrences between sql server 2000 vs 2005

2 Answers   Thomson Reuters,

---

Explain what is scheduled job and how to create it?

0 Answers  

---

What is the purpose of forms?

0 Answers  

---