Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 50038 Views
- Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain, I also Faced
- E-Mail Answers
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 sql server database?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What are the differences between DDL, DML and DCL in SQL?
what's sql server? : Sql server database administration
What are null values in ms sql server?
What is a with(nolock)?
Which table keeps information about stored procedures?
Is sql server implemented as a service or an application? : Sql server database administration
What is an etl file?
When you use @@error and try-catch?
What is single-user mode?
what are defaults? : Sql server database administration
Explain sql server service broker?
What is SQL Azure Fabric?
What are logical database components? : SQL Server Architecture
