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
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What is the advantage of sql server?
What is the difference between dataadapter and datareader?
Explain the concepts and capabilities of sql server?
What are the hotfixes and patches in sql server?
Do you know sql server 2008 backup compression?
What is ddl and dml commands?
Explain the disadvantages/limitation of the cursor?
How to make remote connection in database?
Define normalisation?
How data can be copied from one table to another table?
optimization techinques
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?
How to generate create view script on an existing view?
How do you open a cluster administrator?