how many instance use in sql server 2005

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If we delete pack Spec what will be the status of pack Body ?

961


Define cross join in sql server joins?

580


What is sql server locking?

542


What the difference between UNION and UNIONALL?

563


How many types of keys are there?

522






Write a program to fetch first 10 records from a file?

596


What are the operating modes in which database mirroring runs?

597


what is an extended stored procedure? : Sql server database administration

490


What is the purpose of data source?

507


How to set database to be read_only in ms sql server?

546


How to encrypt data between dialogs?

559


Explain different types of locks in sql server.

589


What are rows and columns?

509


Describe and explain about SQL native client?

606


What are ddl triggers and types of ddl trigger?

600