I had a problem where some of the data menus had duplicate entries (like the following):
It happens because the VSTS 2008 Database Edition and the VSTS 2008 Database Edition GDR are both installed side by side, so you get additional menu entries.
Gert Draper posted instructions to fix this at Home of the Data Dude : Dealing with Confused Installations. They are:
1. Make sure that Visual Studio (devenv.exe) is closed.
2. Start an elevated command prompt.
3. Run the following two commands:
"%ProgramFiles%\Microsoft Visual Studio 9.0\DBPro\DBProRepair.exe" RemoveDBPro2008
"%ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE\devenv.exe" /ResetUserData
4. Restart Visual Studio.
Now, I’m running in 64-bit mode. So, for me, I have to run:
And there’s one more thing—the “/ResetUserData” switch unsets any options you had set—fonts, view preferences, etc. You might want to export any settings you care about first.