Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

how many instance use in sql server 2005

Question Posted / arun.cnb

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

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

Can binary strings be converted into numeric or float data types?

0 Answers  

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

Explain about remote stored procedure?

0 Answers  

Do you know exporting and importing utility?

0 Answers  

what are the Prerequisites for Replication?

1 Answers   IBM,

How do you delete duplicate records in sql server?

0 Answers  

What is 2nf example?

0 Answers  

Define synonym?

0 Answers  

Explain sp_configure commands, set commands?

3 Answers  

Is it possible to call a stored procedure within a stored procedure?

0 Answers  

how to determine the service pack currently installed on sql server? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories