There is a ton of material out there that discusses the new features of SQL Server 2000. From XML support to indexed views and user-defined functions, there info for it. Take a look at Microsoft site and the msdn site, msdn.microsoft.com. SQL Server magazine publishes a lot of material on SQL Server 2000.

I'm happy to try to answer specific questions if you post them.

-Mike