Hi Check this link which is What's New in SQL server 2005 http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx http://msdn2.microsoft.com/en-us/library/ms170363.aspx
Good question Ranjit, as it pertains very open question to answer and by default the answer can be found from SQL Server 2005 books online at What's new section - http://sqlserver-qa.net/blogs/tools...able-for-download-update-your-local-copy.aspx fyi.