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
What is postgresql server?
What is normalization? What number of normalization shapes are there?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
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.
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
What are the different types of subquery?
What is difference between index and primary key?
Explain about link server in sql server?
Can a function call a stored procedure in sql server?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
How to create a view using data from another view?
How do you delete duplicate rows in sql server?
What are distributed partitioned views?
Explain “not null constraint” in sql server?
What is difference between count (*) and count column?