Re: Kludgy SQL Management Studio behavior

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
Date: Thu, 21 Jun 2007 22:29:35 +0000 (UTC)

(pshroads@xxxxxxxxx) writes:

2. When opening a file the file is always opened in a new connection
window. Sometimes I'd just like to open a file using my existing
conneciton.

Do you want to include the file in the existing window, just Query Analyzer
would do? You can do this with Edit->Insert File as Text (Ctrl+Shift-P)

As for Mgmt Studio in general, there are some nice things, but overall
I prefer Query Analyzer. There are several things that Microsoft did do
right in Mgmt Studio.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

References:
- Kludgy SQL Management Studio behavior
  - From: pshroads

Prev by Date: Re: Error creating new database diagrams in upgraded database
Next by Date: Re: How to generate SQL script for initial data?
Previous by thread: Re: Kludgy SQL Management Studio behavior
Index(es):
- Date
- Thread

Relevant Pages

Re: db_ddladmin rights in Management Studio
... a difference in behavior between Management Studio and Query Editor. ... I'm new to SQL Server 2005's security model, ... I ran Profiler to see what queries Mgmt Studio runs, ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.security)
Re: Using VSS to manage stored procedures with SSMS
... Visual Source Safe within the SSMS environment? ... There is indeed SourceSafe integration in Mgmt Studio if that is what ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.security)
Re: SSMS Query Editor... Vs Query Analyser
... > 1) If you want to replace a file in the window, ... > CTRL-SHIFT-Delete to clear the window ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.tools)
Re: SELECT * vs SELECT col1, col2
... I would guess that SQL Server caches system tables more or less like ... And in another window I tried to running SELECTs against the Orders table, ... this may be different in DB2. ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)
Re: Hiding NULL
... There are many features in QA that did not make it to Mgmt Studio. ... again, in Mgmt Studio, it's easier to copy and paste from grid, as you ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)