Visual Studio 2008 Support for SQL Server 2008

This CTP enables developers to use Visual Studio 2008 with SQL Server 2008 Nov CTP.

This CTP resolves a problem that when you try to open a database connection to SQL Server 2008 by using Visual Studio 2008 design tools, you may receive the following error message:
“This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.”

This CTP addresses this issue, and enables the following Visual Studio functionality for SQL Server 2008:

  • Server Explorer successfully connects to SQL Server 2008, and database objects such as stored procedures and table data can be viewed and edited. Note that table schemas still cannot be viewed or edited in this release.
  • SQL CLR projects that target SQL Server 2008 can be created and deployed to the server.
  • T-SQL and SQL CLR debugging are now enabled for SQL Server 2008.
  • Data binding features in Client and Web Projects are enabled.

This CTP does not support the following features for SQL Server 2008:

  • Creating and editing table schemas in Table Designer or Database Diagrams. The table designer feature in SQL Server Management Studio 2008 can be used to edit table schemas in SQL Server 2008.
  • Using the LINQ to SQL Designer with SQL Server 2008

This CTP only supports the English version of the Visual Studio 2008 Product.

Known Issues:

  • Stepping into or hitting a breakpoint in SQL CLR code does not work after enabling SQL CLR debugging on the project and on the server. Workaround: Prior to running the debugger, open the Server Explorer tool window and ensure the Assemblies node is expanded.
  • When you uninstall the CTP on a computer that is running Windows Vista, you may receive an uninstall error message. To work around this problem, provide the Visual Studio installation media, or the installation network location

Download at Microsoft Download Center.