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 do you manipulate data?
Can we use trigger new in before insert?
What does asynchronous call backs means?
what is the sql equivaent of the dataset relation object ?
Name few of the dcl commands in sql?
Why do we use trigger?
What are exact numeric data types in ms sql server?
Can you pass expressions to function parameters?
How can you swap values between two rows in a table using single- SQL statement?
1 Answers Tavant Technologies, Virtusa,
How you can minimize the deadlock situation?
do you know how to configure db2 side of the application? : Sql server database administration
What is the sql case statement used for?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)