Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support

This update resolves the following error that when you try to use Microsoft Visual Studio 2005 Service Pack 1 design tools to open a database connection to Microsoft SQL Server 2008 :

“This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.”

This update 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 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 update does not support the following features for SQL Server 2008:

• Creating and editing table schemas in Table Designer or Database Diagrams. As a workaround you may use the table designer feature in SQL Server Management Studio 2008 to edit table schemas in SQL Server 2008.

Windows 2000 Service Pack 4, Windows Server 2003 R2 (32-Bit x86), Windows Server 2003 R2 x64 editions, Windows Server 2003 Service Pack 1, Windows Server 2003 Service Pack 2, Windows Server 2003 x64 editions, Windows Vista, Windows XP Professional x64 Edition , Windows XP Service Pack 2