I recently re-installed my Visual Studio 2008 including Visual Studio Database Edition. I opened a project from TFS that included some database project (.dbproj) files. As the solution loaded I got some errors relating to the dbproj
The imported project "C:\Program Files(x86)\MSBuild\Microsoft\VisualStudio\v9.0\TeamData\Microsoft.Data.Schema.SqlTasks.targets " was not found. Confirm that the path in the <Import> declaration is correct, and that the file exists on disk.
The issue in this case was that the version of my Visual Studio Database Edition was not the same as the one that had created the database projects. The fix for this was to install the GDR 2 for Visual Studio 2008 Database Edition. Thankfully quite simple.