Which version of MS SQL Server should I choose?
Unless you have a specific reason to choose otherwise, we recommend using MS SQL 2008, the newest version of MS SQL.
Here is a brief summary of our MS SQL Server offerings:
- MS SQL 2008 — The most current version of the SQL Server software from Microsoft®, who will continue to develop features, bugfixes and security fixes.
- MS SQL 2005 — The previous version of the SQL Server software. New releases are issued for critical bugfixes and security fixes. No significant new features are to be added to this series.
For more information regarding the differences between MS SQL Server 2005 and 2008, see Microsoft's documentation, What's New (SQL Server 2008 R2).