Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


how many instance use in sql server 2005

Answers were Sorted based on User's Feedback



how many instance use in sql server 2005..

Answer / trived

normally sql sever 2000 16 instance possible
in 2005 50 instance possible

Is This Answer Correct ?    26 Yes 2 No

how many instance use in sql server 2005..

Answer / setaceo

In Workgroup Edition : 16 Instances
In Enterprise/Developer/Standard Editions : 50 Instances

Is This Answer Correct ?    10 Yes 2 No

how many instance use in sql server 2005..

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

how many instance use in sql server 2005..

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

Post New Answer



More SQL Server Interview Questions

What are the different types of sub-queries?

0 Answers  


Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  


How to assign null values to variables or columns?

0 Answers  


What does <> symbol mean?

0 Answers  


What stored procedure can you use to display the current processes?

0 Answers  






What is row by row processing ?

2 Answers  


Why we should not use triggers?

0 Answers  


What are cursors and when they are useful?

0 Answers  


Different types of keys in SQL?

0 Answers   Infosys,


What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

0 Answers  


What are different types of constraints?

0 Answers  


What is replace and stuff function in sql server?

0 Answers  






Categories