List of breaking changes in SQL 2005
Here's a handy list I just discovered today that shows the features supported in SQL 2000 which have been broken in SQL 2005. Handy for anyone doing upgrade projects..
http://msdn2.microsoft.com/en-us/library/ms143532.aspx