Just a small post on a new download that's available on Microsoft Download: Visual Studio 2008 Support for SQL Server 2008, Community Technology Preview.
Using this CTP, you can now have your Server Explorer in Visual Studio 2008 successfully connect to SQL Server 2008 and have it show tables and stored procedures. Other resolved issues can be found on the download page.
Unfortunately, the CTP does not make it possible yet to use LINQ to SQL with SQL Server 2008.
Download can be found here.