how many instance use in sql server 2005
Answer Posted / setaceo
In Workgroup Edition : 16 Instances
In Enterprise/Developer/Standard Editions : 50 Instances
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
what are defaults? : Sql server database administration
When would you use it?
Write a program to fetch first 10 records from a file?
What is xml datatype?
What does set rowcount do?
what happens on checkpoint? : Sql server database administration
What is an execution plan? How would you view the execution plan?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
How to remove duplicate rows from table?
what is the difference between Delete and Truncate command in SQL
Explain primary key and foreign key constraints?
What is self contained multi valued query?
Does hive support indexing?
What is the benefit of normalization?
Explain isolation levels that sql server supports?