how many instance use in sql server 2005
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
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/
Is This Answer Correct ? | 1 Yes | 3 No |
How to use go command in "sqlcmd"?
What is sql service broker?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
when you create a database how is it stored? : Sql server database administration
What is constraints and its types?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is scheduled job and how to create it?
What are rows and columns?
What is read committed?
How can we rewrite sub-queries into simple select statements or with joins?
Define full outer join in sql server joins?
How to use group functions in the select clause in ms sql server?