Re: SSMS Query Editor... Vs Query Analyser
Keep venting. I'm sure there are at least 100 more things you can find.
But, keep in mind that there are also at least as many new things you
couldn't do before that are better. I think it's a much needed improvement
over Enterprise Manager. But, I also think it still needs a lot of work.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Alec Steingart" <asteinga@xxxxxxxxxxxxx> wrote in message
news:emaqV6tJGHA.3904@xxxxxxxxxxxxxxxxxxxxxxx
> 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: Enter Todays Date in SSMS Open Table Grid View
... If you don't want to consult your watch, you will have to write an INSERT ... Is there an SSMS ... 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: View Columns do not show in Object Explorer
... up in SSMS, and that's where Object Explorer lives. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.tools) - 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) |
|
