Gert Drapers has announced the June CTP of the Visual Studio Team System 2008 - Database Edition GDR which has - among many other improvements - support for SQL Server 2008. 
Apart from the SQL Server 2008 support, other additions certainly worth mentioning are partial and composite projects.  This will allow for great flexibility on how you structure your database projects.

Please check out more details here because there are other nice changes.