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

Re: Starting Management Studio

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.fsmpi.rwth-aachen.de!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Starting Management Studio
Date	Thu, 18 Sep 2014 21:43:41 +0200
Organization	Erland Sommarskog
Lines	33
Message-ID	<XnsA3ACDD083B813Yazorman@127.0.0.1> (permalink)
References	<MPG.2e83b6b2f6a853b798968a@news.powerusenet.com>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx05.eternal-september.org; posting-host="033ac5a0907689904aec6a4990ff1e17"; logging-data="7089"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18M6ypYtYG+mpZx3mm3wvBl"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:E+ceHn30t6fxQc4NvQQnbnUyJI4=
Xref	csiph.com comp.databases.ms-sqlserver:1808

Show key headers only | 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