June 12, 2011 at 5:10 pm
in sql server 2008 r2 the instances are (named+ default) 50+1 or 49+1
June 12, 2011 at 5:14 pm
Thankyou in advance
June 12, 2011 at 10:29 pm
What do you mean?
Best Regards,
Ashkan
June 12, 2011 at 10:37 pm
aarunkumarreddy (6/12/2011)
in sql server 2008 r2 the instances are (named+ default) 50+1 or 49+1
Is this a trick question? 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 12, 2011 at 10:38 pm
Anyway, If you mean how many instances you can create:
SQL Server 2008 Enterprise Edition and Standard Edition support 50 instances. SQL Server 2008 Workgroup Edition supports 16 instances.
Ref: Maximum Capacity Specifications for SQL Server - http://msdn.microsoft.com/en-us/library/ms143432.aspx
So You can only create 50 instances (50+0) or(49+1):D
Best Regards,
Ashkan
June 12, 2011 at 10:41 pm
thankyou guys
June 12, 2011 at 11:09 pm
😀 yes Welsh, I guess so!:D
Best Regards,
Ashkan
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply