From: esquel@sommarskog.se   
      
   Jim (jgeissman@socal.rr.com) writes:   
   > At work we used to have XP and then we got new computers with Windows 7,   
   > a distinct improvement. I have SQL 2008 Management Studio on both. Under   
   > XP, when I would double click a SQL script, Windows would open   
   > Management Studio if it wasn't already running, but if it was already   
   > up, it would merely add a new tab with the new script, attached to the   
   > same server and database as the previously active tab. I liked that. On   
   > the new computer, Windows always opens a new instance of Management   
   > Studio, whether or not it is already running. I would like to change it   
   > back to the old behavior. I've been Googling around for how to do that,   
   > but haven't found anything. Anybody know?   
      
   On a Win7 machine where I have .sql files mapped to SSMS it works as   
   desired. That is, double-clicking on a file opens a new tab in the   
   existing instance of SSMS.  ...unless SSMS has a blocking dialog like   
   the connection dialog open. I don't know if this can be a clue.   
      
   I should quickly add that this is SSMS2014; I don't have any Win7   
   machine where SSMS 2008 is the default. But I don't really think it   
   is a difference. Or, hm, SSMS 2008 is older than Win7. Could be a   
   compatibilty issue. Particularly if you have the RTM version. What   
   does Help->About report?   
      
   Or install SSMS2012, which I think is nicer than SSMS 2008. You can get   
   it for free at   
   http://www.microsoft.com/en-us/download/details.aspx?id=43351   
      
   But don't get SSMS 2014 - they have a serious flaw in that version.   
      
      
      
   --   
   Erland Sommarskog, Stockholm, esquel@sommarskog.se   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)