SQL Server 2005, Visual Studio 2008 Editions - which one to choose?

There are a bunch of editions for each.

There are 6 SQL Server 2005 Editions:
1.Enterprise Edition
2.Standard Edition
3.Workgroup Edition
4.Express Edition
5.Developer Edition
6.Compact Edition

It can be enlightening for Project planners & the deployment folks to know about the feature differences.

SQL Server 2005 Express Edition with Service Pack 1 will run on Windows Vista but has known issues with User Access Control. For all other editions of SQL Server 2005, Service Pack 2 will be required for Windows Vista and Windows Server "Longhorn" support when those products are released.

SQL Server 2000 (including MSDE) is not supported on Windows Vista or Windows Server “Longhorn”.

The Visual Studio 2008 Product Comparison page on MSDN has a comprehensive comparison of the features of the different editions:
1.Visual Studio 2008 Express Editions (VWD, VB, C#, C++)
2.Visual Studio 2008 Standard
3.Visual Studio 2008 Professional
4.Visual Studio Team System 2008 Architecture Edition
5.Visual Studio Team System 2008 Database Edition
6.Visual Studio Team System 2008 Development Edition
7.Visual Studio Team System 2008 Test Edition
8.Visual Studio Team System 2008 Team Suite

Related link:
List of Vista Supported Hardware & Software