Difference between sql server 2000 and sql server 2005?
Answer Posted / amit singh
1. In SQL Server 2000 the Query Analyzer and Enterprise
Manager are seperate,whereas in SQL Server 2005 both were
combined as Management Studio.
2. In Sql 2005,the new datatype XML is used,whereas in Sql
2000 there is no such datatype
3. In Sql server2000 we can create 65,535 databases,whereas
in Sql server2005 2(pow(20))-1 databases can be created.
| Is This Answer Correct ? | 202 Yes | 17 No |
Post New Answer View All Answers
What is data block and how to define data block size?
How exceptions can be handled in sql server programming?
What is the report model project?
What is the main purpose of having conversation group?
What is normalization process?
How to create user defined functions with parameters?
What are data regions?
how to create “alternate row colour”?
Explain the microsoft sql server delete command?
When does a workload on SQL Azure get throttled?
How network traffic be reduced by using the stored procedure?
What is a system database and what is a user database?
What is query processing?
What is a trace frag?
What is the standby server?