|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SSMS Query Editor... Vs Query AnalyserWhen 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. Thanks ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... t***@yahoo.com (S.Ramaswamy) writes:
> When already connected to a database, if you open a .SQL file, SSMS CTRL-SHIFT-P, or Edit->Insert File As Text has quite some QA feel to it.> 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. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se 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 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. Show quote "Erland Sommarskog" <esq***@sommarskog.se> wrote in message news:Xns97595915E286Yazorman@127.0.0.1... > t***@yahoo.com (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, esq***@sommarskog.se > > 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 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. -- Show quoteMike 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" <astei***@optonline.net> wrote in message news:emaqV6tJGHA.3904@TK2MSFTNGP10.phx.gbl... > 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" <esq***@sommarskog.se> wrote in message > news:Xns97595915E286Yazorman@127.0.0.1... >> t***@yahoo.com (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, esq***@sommarskog.se >> >> 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 > > "Michael Hotek" <m***@solidqualitylearning.com> wrote in message Only 100?news:e6dJZuwJGHA.2088@TK2MSFTNGP11.phx.gbl... > 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. > I was really looking forward to using SSMS to develop my SQL2000 DBs, and instead it looks like I'll use QA to develop my SQL2005 DBs... Yes they have improved some aspects, but broken others... I find it a nightmare that I can only view 3 or 4 query tabs at one time. And when the overflow dropdown lists near-identical names for the hidden tabs, how do you know which one to pick? In QA, I moved the minimized windows to different areas of the MDI screen to group them logically, but you can't do this with a tabbed interface. It would be useful if you could name the windows (temporarily, without having to save the SQL to a file). And as for the speed.... I've installed 2005 on my shiny new dual-core Pentium with 2GB RAM, and expected it to fly, but both VS.NET 2005 and SQL 2005 are slow and cumbersome... Is there a way to feed any of this back to MS? Do they care? Are there any plans for upgrades and improvements? CJM CJM (cjmnews04@newsgroup.nospam) writes:
> Yes they have improved some aspects, but broken others... I find it a Boy, then there are two of us! The did a change fairly late in the beta,> nightmare that I can only view 3 or 4 query tabs at one time. And when > the overflow dropdown lists near-identical names for the hidden tabs, > how do you know which one to pick? In QA, I moved the minimized windows > to different areas of the MDI screen to group them logically, but you > can't do this with a tabbed interface. It would be useful if you could > name the windows (temporarily, without having to save the SQL to a > file). so now the server name is always displayed. But still this file name is pure junk to me, as mainly use QA/SSMS for ad hoc queries. (Programming I do in Textpad.) But you don't have to use the tabs. Under Tools->Options (or if it's Customize, can't keep them apart), you can select between tabbed docs and MDI. > Is there a way to feed any of this back to MS? The place to go to is http://lab.msdn.microsoft.com/ProductFeedback/.You can submit your own suggestions, and also search for existing bugs/suggestions and vote for them. >Do they care? Yes.> Are there any plans for upgrades and improvements? Well, I don't think SQL 2005 is the last version of SQL Server.But don't expect any significant changes in functionality within SQL 2005. I guess this could happen for occassional issues where there is a very strong user feedback. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se 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 Alec Steingart (astei***@optonline.net) writes:
> 1) If you want to replace a file in the window, you have to Not that big deal...> CTRL-SHIFT-Delete to clear the window > 2) More annoying: there's no recent file list for Insert File as Text (nor I do this so rarely, that this is not a problem...> 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 But this one! You can bet, that I kept screaming about this one during> close SSMS. the beta programme. I have submitted a suggestion for this on Ladybug. You can vote on it if you like: http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx?feedbackid=b28b4a47-fb76-42aa-a882-94b9ba891b14 -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se 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  |
|||||||||||||||||||||||
Other interesting topics