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
Explain stored procedure?
Which language rdl files made of?
How to create new tables with "create table" statements in ms sql server?
Differentiate between a local and a global temporary table?
What are the tables in sql?
What is self contained multi valued query?
What is the impact on other user sessions when creating indexes?
How do you trace the traffic hitting a sql server?
How do you run a trace?
Give the query of getting last two records from the table in SQL SERVER?
Explain trigger and its types?
What is the difference between a stored procedure and a user defined function?
What is default constraint?
What is user defined datatypes and when you should go for them?
In how many ways you can invoke ssrs reports?