Re: SSMS Query Editor... Vs Query Analyser

Unfortunately, it falls a little short:

1) If you want to replace a file in the window, you have to 
CTRL-SHIFT-Delete to clear the window

2) More annoying: there's no recent file list for Insert File as Text (nor 
do the files you open this way go on the recent file list)

3) I haven't found an option to turn off the prompt to save files when you 
close SSMS.

I'm just venting my frustration with the SQL 2005 tools. I know you were 
just trying to make a helpful suggestion.

"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message 
news:Xns97595915E286Yazorman@xxxxxxxxxxxx
> trsv@xxxxxxxxx (S.Ramaswamy) writes:
>> When already connected to a database, if  you open a .SQL file, SSMS
>> prompts for database connection again, where as in Query Analyser if you
>> open a .SQL file it will simply bring  the text into the  editor. In
>> SSMS there is an additional clik involved. Is there a way to customize
>> SSMS so that it behaves the way QA does.
>
> CTRL-SHIFT-P, or Edit->Insert File As Text has quite some QA feel to it.
>
>
> -- 
> 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 


.

Relevant Pages

  • 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: SSIS - can SSIS pkg recognize a drive letter within SMS job?
    ... Realized from your process description that you were running SSMS from your ... I normally run SSMS on our Sql Server using a remote (terminal ... Uploaded the SSIS package which was simple and just contained one ... What is your SQL Server Agent service account? ...
    (microsoft.public.sqlserver.dts)
  • RE: SQL 2005 Management Studio cant edit text rows with > 4000 ch
    ... in SSMS, I cannot do the same thing. ... a text field, if I edit the int field, it fails. ... In SQL Server no matter 2000 or 2005, the default maximum size that can be ... table name','text in row',7000", the text-type field can support maximum ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Server Management Studio Cannot Open SQL Express Files
    ... Currently I can work with the DB in SSMS but not in VS. ... I suggest you to open SQL Server Configuration Manager and see how many SQL ... If I create the database in VS2005 using the ... If I create the DB in Management Studio I cannot work with it in VS2005. ...
    (microsoft.public.sqlserver.tools)
  • Re: Cannot find a GUI to execute a query
    ... you'll still have SSMSE 2008. ... SSMSE but there are some other features, like SQL Server Profiler, that I ... I guess I can still 'Script Stored Procedure As Execute To' a new window, ... How about using SSMSE instead of SSMS? ...
    (microsoft.public.sqlserver.tools)
Loading