Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1808

Re: Starting Management Studio

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Starting Management Studio Jim <jgeissman@socal.rr.com> - 2014-09-17 16:18 -0700
  Re: Starting Management Studio Erland Sommarskog <esquel@sommarskog.se> - 2014-09-18 21:43 +0200
    Re: Starting Management Studio Ross Presser <rpresser@gmail.com> - 2014-09-19 08:53 -0700
      Re: Starting Management Studio Erland Sommarskog <esquel@sommarskog.se> - 2014-09-19 21:43 +0200

csiph-web