Difference between SQL Server 2000 and Sql Server 2005

S.No	SQL Server 2000	SQL Server 2005
1	Query Analyser and Enterprise manager are separate.	Both are combined as SSMS(Sql Server management Studio).
2	No XML datatype is used.	.XML datatype is introduced.
3	We can create maximum of 65,535 databases.	We can create 2(pow(20))-1 databases.
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	DataBase Mirroring facility is not available	DataBase Mirroring facility is introduced
8	RowNumber function for paging is not available	RowNumber function for paging 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