Visual Studio 2008 Menu Items Duplicated

Question

I occasionally get some issues with Visual Studio and ReSharper that causes me to run

devenv.exe /ResetSettings

After doing this, the menu items under "Data" are all duplicated, and each section is duplicated. So it now looks like this:

Show Data Sources
Add New Data Source...
-------------------------
Schema Compare
Schema Compare
Data Compare
Data Compare
-------------------------
Schema Compare
Schema Compare
Data Compare
Data Compare
-------------------------
Refactor
Refactor
-------------------------
Refactor
Refactor
-------------------------
T-SQL Editor
T-SQL Editor
-------------------------
T-SQL Editor
T-SQL Editor
-------------------------
Static Code Analysis
-------------------------
Schema View

I have the MS Visual Studio Team System 2008 Database Edition GDR 2 installed, and I think that is what's causing the issue.

Is there a way to remove the duplicated items, or better yet, stop this from happening?

Answer 1

I found this msdn article which seems to illustrate your problem and how to fix it.

FTA

1. Close all instances of Visual Studio Team System 2008 editions.

2. At the Windows Command Prompt, type the following command:

   %ProgramFiles%\Microsoft Visual Studio 9.0\DBPro\DBProRepair.exe RemoveDBPro2008

3. Press ENTER.

4. At the Windows Command Prompt, type the following command:

%ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE\devenv.exe /ResetUser