Answers were Sorted based on User's Feedback
Answer / trived
normally sql sever 2000 16 instance possible
in 2005 50 instance possible
|Is This Answer Correct ?||26 Yes||2 No|
Answer / setaceo
In Workgroup Edition : 16 Instances
In Enterprise/Developer/Standard Editions : 50 Instances
|Is This Answer Correct ?||10 Yes||2 No|
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.
|Is This Answer Correct ?||2 Yes||1 No|
Answer / varinder sandhu
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 :
|Is This Answer Correct ?||1 Yes||3 No|
What are the different types of sub-queries?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How to assign null values to variables or columns?
What does <> symbol mean?
What stored procedure can you use to display the current processes?
What is row by row processing ?
Why we should not use triggers?
What are cursors and when they are useful?
Different types of keys in SQL?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What are different types of constraints?
What is replace and stuff function in sql server?