how many instance use in sql server 2005

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

605


What is the advantage of sql server?

512


What is the difference between dataadapter and datareader?

520


Explain the concepts and capabilities of sql server?

521


What are the hotfixes and patches in sql server?

531






Do you know sql server 2008 backup compression?

547


What is ddl and dml commands?

492


Explain the disadvantages/limitation of the cursor?

543


How to make remote connection in database?

573


Define normalisation?

652


How data can be copied from one table to another table?

491


optimization techinques

2177


What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

616


How to generate create view script on an existing view?

544


How do you open a cluster administrator?

608