The August Edition of MSDN has a very good (and very long) article on SQL Server 2000. It's focused mostly on programming features but has some admin stuff in there too. Some of the more interesting topics included user defined functions, table and variant datatypes and XML processing.