SOLVED: 5.3.2 - Format SQL twice in right-click menu

• 
  Hello,
  
  This has happened to our customers about three times, but it's rare and nobody can replicate the issue at will. The developers claim it "shouldn't happen" in 5.2.x because the offending code imported from the old SQL Refactor tool had been re-written.
  
  You may be able to reset the menus, at least temporarily, by resetting the SSMS dev environment:

  SSMS 2005: “C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlwb.exe†/setup
  SSMS 2008: “C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\ssms.exe†/setup
  SSMS 2012: “C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\ssms.exe†/setup
  

  Brian Donahue May 11, 2012 04:32

  - 0 +
• 
  Thanks, I think, Brian.
  
  What will "resetting the dev environment" actually do? I have customized it over 18 months to exactly how I want it - I will not take the risk of losing all that...
  
  Please expand upon your post.
  
  Thanks.

  PDinCA May 11, 2012 12:28

  - 0 +
• 
  I don't believe that /setup removes any of your customisations - I think it just tells addins to reinitialise themselves. I'm not certain though - it's not well documented.
  
  The safer thing to try first would be to completely uninstall SQL Prompt, run SSMS without SQL Prompt installed, then close SSMS and reinstall SQL Prompt. That should clean up the menus.
  
  By the way, from your other bug reports, I suspect this problem is related to the crash you saw on the first startup after upgrading SQL Prompt. It probably crashed while creating the menus, and left orphaned items.

  Mike U May 14, 2012 07:07

  - 0 +
• 
  By "completely unistall" are you referring to the RG uninstall or the more thorough Revo Uninstaller? I use Revo when I need to nuke everything because there's a defect that has no workaround and requires a "machine cleanse".
  
  I need to save my aliases as last time I did a Revo uninstall, there they were gone! It would be a neat feature to be able to EXPORT then IMPORT -huh? Yes, and apparently http://redgate.uservoice.com/forums/944 ... pt-options is "Under Review" but nobody on the outside knows "since when"... (I have no votes left on Uservoice, BTW, even with 25 votes applied or I would have added my 3 to this one!)
  
  I've done the copy-file, copy-paste before but what a pain to have to do that for want of an export-import just like Snippets.
  
  Please advise on the degree of uninstallation needed. Thanks.

  PDinCA May 14, 2012 13:03

  - 0 +
• 
  Just the Red Gate uninstall should be sufficient.

  Mike U May 14, 2012 13:38

  - 0 +
• 
  The uninstall, run ssms.exe /setup, SSMS, close, install worked, thanks.
  
  Changed post title to SOLVED.

  PDinCA May 14, 2012 14:38

  - 0 +

Add comment

Please sign in to leave a comment.