Difference between MS SQL 2005 & SQL Server 2000 - SQL Server Tutorials

What is the Difference between SQL server 2000 & 2005

In my previous article I explained about What is SQL Server? - An Overview | SQL Server Tutorials. In this article I will explain the differences between MS Sql 2000 & 2005 Database.

Microsoft SQL Server 2005 extends the performance, reliability, availability and ease-of-use of SQL Server 2000. There are following difference between MS SQL Server 2000 and MS SQL Server 2005 :- 

S.no	MS SQL Server 2000	MS SQL Server 2005
1	Query Analyser and Enterprise manager are separate.	Both are combined as SSMS (SQL Server Management Studio)
2	We can create maximum of 65,535 databases.	We can create 2(pow (20))-1 databases.
3	No XML data type is used.	.XML data type is introduced.
4	Exception Handling mechanism is not available	Exception Handling mechanism is available
5	There is no Varchar(Max) data type is not available.	Varchar(Max) data type is introduced.
6	DDL Triggers is not available	DDL Triggers is introduced
7	RowNumber function for paging is not available	RowNumber function for paging is introduced
8	DataBase Mirroring facility is not available.	DataBase Mirroring facility is introduced
9	Table fragmentation facility is not available.	Table fragmentation facility is introduced
10	Full Text Search facility is not available.	Full Text Search facility is introduced.
11	Bulk Copy Update facility is not available.	Bulk Copy Update facility is introduced
12	Data Encryption concept is not introduced.	Cannot encrypt the entire database
13	Cannot compress the tables and indexes.	Can Compress tables and indexes.(Introduced in 2005 SP2)
14	No varchar(max) or varbinary(max) is available.	Varchar(max) and varbinary(max) is used.
15	Data Transformation Services(DTS) is used as ETL tool	SQL Server Integration Services(SSIS) is started using from this SQL Server version and which is used as ETL tool