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

What is postgresql server?

516


What is normalization? What number of normalization shapes are there?

611


What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

480


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1100


You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

243






What are the different types of subquery?

619


What is difference between index and primary key?

594


Explain about link server in sql server?

535


Can a function call a stored procedure in sql server?

529


How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

559


How to create a view using data from another view?

572


How do you delete duplicate rows in sql server?

510


What are distributed partitioned views?

627


Explain “not null constraint” in sql server?

527


What is difference between count (*) and count column?

527