XML services is provided in 2005 not in 2000

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.

Sql server 2005 New features:
1.Datatype varchar(max),XML datatype
2.OUTPUT Clause
3.APPLY OPERATOR
4. PIVOT and UNPIVOT?
A Pivot Table can automatically sort, count, and total the 
data stored in one table or spreadsheet and create a second 
table displaying the summarized data. The PIVOT operator 
turns the values of a specified column into column names, 
effectively rotating a table.

5.Tools and utilities 
Data types 
T-SQL enhancements 
Programmability enhancements 
XML support 
Native XML web services 
SQL Management Objects 
SQL Server Integration Services 
SQL Server Reporting Services 
SQL Server Notification Services 
SQL Server Service Broker 
Replication Management Objects 
SQL Server Agent 
SQL Server Mobile Edition 
The code used in the book is available 

In sql server2000 Extended Stored procedures , and it 
modified it into CLR Stored procedures 

nd sql server 2005