We've been getting a few questions by our users about Visual Studio 2010's support for SQL Server versions. So I thought it would be good to address them here (when one person asks a question, there are probably others thinking the same question.) Visual Studio 2010 only supports SQL Server 2005+ Visual Studio 2010's design time data tooling only supports SQL Server 2005 (including express editions) or later. What this means is that you will not be able to connect through the Server/Database Explorer to any older versions of SQL Server or use any of the data design tools that require Visual Studio to connect to the database (LINQ designer, datasource wizard, table editing, etc.) This does not mean that your ASP.NET pages will stop working; the...(read more) ...
Go to the complete details ...