Thanks Steve, that was good article. Some of the features i really like in SQL Server 2005 are
- CTEs.
- XML Support.
- Try catch blocks
- Online indexings.
- CLR integration.
If your application does not need any of the new features of SQL Server 2005, i personally feel there is no need to upgrade.
Regards,
Sudheer