views:

954

answers:

5

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?

A: 

I haven't seen this before but you can likely fix it by doing a repair on the installation via Add / Remove Programs.

I know that's a pretty big hammer to use, but it will likely fix the problem.

JaredPar
Not sure why I got downvoted here. Explanation please?
JaredPar
Not sure, but actually Add/Remove didn't work for me last time, or when I re-installed I made the same mistake as I'd presumably done originally (install GDR then GDR 2 over the top?). Well it's finally working now...
piers7
+5  A: 

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

Joseph
Btw, /ResetUser wasn't a valid option, which was strange. I just did /ResetSettings and that worked fine.
Josh Close
A: 

Thank you, that fixed my issue, except when I ran the last command, it told me that it was not a valid command, so I issued /ResetSettings instead of /ResetUser. It's fixed now.

Allison Christiansen
This is not an answer. It should have been a comment to the accepted answer.
Todd Ropog
A: 

After calling

DBProRepair.exe RemoveDBPro2008

the menu entry "Data" in Visual Studio was disappeared. I had to run

DBProRepair.exe RestoreDBPro2008

to get it back in Visual Studio.

gsharp
A: 

I tried the whole ResetSettings and it didn't work. What I did do that worked for me was:

(All in directory Users\\AppData\Local\Microsoft\VisualStudio) 1.) Copy the 10.0 directory somewhere where you can reference it later 2.) Delete the 10.0 directory. 3.) Boot Visual Studio 2010 and voila!

All my plugins and everything were still intact. I'm not sure what side-effects there will be, and I didn't have a terribly customized environment.

BlackjacketMack