Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSMS Strange Behavior Expand / Collapse
Author
Message
Posted Thursday, December 12, 2013 7:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 2:29 PM
Points: 135, Visits: 91
I am having an exceedingly strange issue with SSMS. When opening new sql files (from explorer or file->open) or query windows (file -> new), if no change has been made in the active window, SSMS reuses the same tab instead of opening in a new one. This ONLY happens if the I attempt to open multiple scripts at one time or there is no change in the active tab.

So far I have tried just about every registry hack I could find using google, I have reinstalled SQL Server Management Studio twice now, update to the latest service packs, looked through the configuration options in SSMS and have yet to be able to solve this. My coworkers, using the same windows image, are NOT having this problem and they have used the same installation process. The only difference on my system was that visual studio 2008 was installed AFTER installing Sql Server, which caused its own host of other problems, but after removing VS, .Net Frameworks, and SSMS and reinstalling in the correct order those issues appear to be corrected.

I am running SQL Server 2008 Service Pack 3 10.00.5500.00 on windows 7 enterprise.

Any help anyone can provide would go a long way toward making today a less then frustrating experience.

Many thanks,
Wes
Post #1522295
Posted Thursday, December 12, 2013 8:27 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, September 8, 2014 4:07 PM
Points: 1,669, Visits: 2,215
Not sure this post will make your day any easier, but here goes...

You might want to try and build a TEST workstation fresh from the image and install in the correct order, and see if that workstation has the same issue. If not, you transfer your files and transfer only non-SQL Server and non-SSMS settings to that new workstation. That would prove that it's likely a registry issue, although it won't prove exactly what that issue is..

If you really want to spend some serious extra time, you could then choose to compare the registries from the two machines, and maybe you find it, maybe you don't.... It could also be a corruption problem in the registry and sometimes, there's no finding that kind of problem.

The one advantage of this way forward is that you either discover that it's a bug, or that a fresh build solves it. Painful, perhaps, but cleansing....

Let me know how you make out...


Steve
(aka sgmunson)

Internet ATM Machine
Post #1522335
Posted Friday, December 13, 2013 6:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 2:29 PM
Points: 135, Visits: 91
Thanks for the reply, I was hoping more for someone else who has been through this, but alas I stand alone. It is a corporate machine at one of my client sites, so I will just have to have them re-image it and try the installations again. It does make me feel a bit better to know that whatever caused the issue is a mystery to the rest of the community as well though


Wes
Post #1522664
Posted Friday, December 13, 2013 7:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 2:29 PM
Points: 135, Visits: 91
Well, I am a glutton for punishment and I just couldn't let something so silly ride and after thinkning about it the re-image would take just about forever since I have a lot of data that would need to be moved... blah blah blah, etc etc etc.

So after poking around, I found that there is an option in Visual Studio that creates precisely this behavior ("reuse current document window if saved") under Tools->Options->General->Documents, but this is noticeably absent SSMS 2008 (though it exists in 2012). I figure if I can find that registry key and add it to the SSMS configuration, it should work, but after playing around I could not find what registry key this alters. I will do some digging and report back what I find.
Post #1522704
Posted Friday, December 13, 2013 12:23 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 10:20 AM
Points: 1,051, Visits: 2,555
Wesley Middendorff (12/13/2013)
Well, I am a glutton for punishment and I just couldn't let something so silly ride and after thinkning about it the re-image would take just about forever since I have a lot of data that would need to be moved... blah blah blah, etc etc etc.

So after poking around, I found that there is an option in Visual Studio that creates precisely this behavior ("reuse current document window if saved") under Tools->Options->General->Documents, but this is noticeably absent SSMS 2008 (though it exists in 2012). I figure if I can find that registry key and add it to the SSMS configuration, it should work, but after playing around I could not find what registry key this alters. I will do some digging and report back what I find.


Did you change the setting in Visual Studio? There's some overlap between Visual Studio and SSMS when it comes to query windows and they may actually be using the same component.


Jason Wolfkill
Blog: SQLSouth
Twitter: @SQLSouth
Post #1522832
Posted Friday, December 13, 2013 5:55 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 3:47 PM
Points: 1,778, Visits: 5,730
In my registry for SQL2012 I have the setting here:

HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\11.0\General

It is a REG_DWORD value called ReuseActiveDocumentwindow.

You may have similar for SSMS 2008 with 10.0 instead of 11.0


MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1522908
    Posted Monday, December 16, 2013 8:55 AM
    SSC-Enthusiastic

    SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

    Group: General Forum Members
    Last Login: Tuesday, August 19, 2014 2:29 PM
    Points: 135, Visits: 91
    That was it, thanks!

    For SSMS 2008 the key is found at HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General

    Thanks for the help!
    Post #1523283
    Posted Monday, December 16, 2013 4:29 PM


    SSCommitted

    SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

    Group: General Forum Members
    Last Login: 2 days ago @ 3:47 PM
    Points: 1,778, Visits: 5,730
    Wesley Middendorff (12/16/2013)
    That was it, thanks!

    For SSMS 2008 the key is found at HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General

    Thanks for the help!


    Thanks for updating us with the actual location, always nice when that happens. Makes you wonder what else you can do via the registry doesn't it


    MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1523481
    Posted Tuesday, December 17, 2013 7:42 AM


    Ten Centuries

    Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

    Group: General Forum Members
    Last Login: Today @ 10:20 AM
    Points: 1,051, Visits: 2,555
    mister.magoo (12/16/2013)
    Wesley Middendorff (12/16/2013)
    That was it, thanks!

    For SSMS 2008 the key is found at HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General

    Thanks for the help!


    Thanks for updating us with the actual location, always nice when that happens. Makes you wonder what else you can do via the registry doesn't it


    Just be sure to back up that registry before you start rummaging around in there!


    Jason Wolfkill
    Blog: SQLSouth
    Twitter: @SQLSouth
    Post #1523690
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse