Behaviour and Breaking changes from SQL Server 2000 to 2005
These 2 lists are worth having nearby just in case:
Breaking Changes to Database Engine Features in SQL Server 2005
- Describes the changes made to the Database Engine in Microsoft SQL Server 2005
that could cause applications based on earlier versions of SQL Server to break.
Behavior Changes to Database Engine Features in SQL Server 2005
- Describes the changes in behavior of some Database Engine features in Microsoft SQL Server 2005
from their behavior in earlier versions of SQL Server.