how many instance use in sql server 2005

Question Posted / arun.cnb

4 Answers
12424 Views
EFI, HCL, I also Faced
E-Mail Answers

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

Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers

Do you know hot add cpu in sql server 2008?

0 Answers

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers AllState,

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers

Explain having clause and where clause?

0 Answers

Delete duplicate rows without using rowid.

0 Answers Nagarro,

How to modify an existing stored procedure in ms sql server?

0 Answers

What are the common performance issues in sql server?

0 Answers

What is the use of stored procedure?