Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
allpinball
Starting Member
4 Posts |
 Posted - 2010-12-09 : 09:49:05
|
| Of all the things I despise in SQL 2008 SSMS (a list mostly comprised of things that work significantly different than in 2000 EM), the fact the application steals the focus when you mouse over it has got to be the worst...basically means I have to run all applications maximized to prevent SSMS from taking over if I accidentally move the mouse just outside an overlapping application.Is there any way to turn off this major annoyance?Next on the hate list is the loss of the ctrl-+ shortcut to expand all grid columns to fit the data.....every other windows app known to man does this (as did EM)....so why not SSMS? Highlight several columns at once and resize? In EM yes, in SSMS, NO! Change the height of rows in SSMS and it only changes 1 row...even if you highlight several? Did anyone at MS notice this is completely different them the way EM works? Oh, and that SSMS object explorer...whose ideas was it to remove the vertical lines that group the "folders"? Those would be the lines you could double-click in EM to expand/contract the listing. In SSMS now I have to scroll to the very top of the list and click the - button....is this supposed to be an improvement?Sorry about the extended rant.....post was supposed to be only about the stolen focus..... |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-12-09 : 10:14:50
|
| I have never experienced the focus stealing you describe. Do you by any chance have Windows PowerToys or some special mouse driver installed? My guess is there's a setting in there to autofocus on mouseover.You can expand and collapse groups in Object Explorer with the + and - keys on the numeric keypad. I suggest double-checking the keyboard shortcut section of Books Online, I know they changed a number of things in 2008 SSMS. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-09 : 10:18:02
|
| Stolen Focus -- what OS do you have? This must be some Windows setting...doesn't happen to me on XP Pro or Win7 Pro.Highlight and resize columns -- works for me just fine.Double-click to expand nodes -- works for me just fine.But I can't change row height in the grid results either.Might check some of the options you have set. |
|
|
|
allpinball
Starting Member
4 Posts |
Posted - 2010-12-09 : 10:31:05
|
quote:
Originally posted by robvolk
I have never experienced the focus stealing you describe. Do you by any chance have Windows PowerToys or some special mouse driver installed? My guess is there's a setting in there to autofocus on mouseover.You can expand and collapse groups in Object Explorer with the + and - keys on the numeric keypad. I suggest double-checking the keyboard shortcut section of Books Online, I know they changed a number of things in 2008 SSMS.
I've had (XP) PowerToys in the past....regardless of the PT setting, SSMS is the only app that currently behaves this way on my machine.Guess I'll go re-install PT and see if I need to turn somethin goff.+/- for the Explorer will help, but I still miss the grouping lines. Using +/- means I have to click into something, then use the keyboard, whereas the old way just let you point & (double) click anywhere in the explorer to achieve the same thing. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-09 : 10:35:17
|
| It is something you've done in your configuration options.+/- doesn't mean you have to use the keyboard. It works with the mouse and/or the keyboard. |
|
|
|
allpinball
Starting Member
4 Posts |
Posted - 2010-12-09 : 10:44:28
|
quote:
Originally posted by russell
Stolen Focus -- what OS do you have? This must be some Windows setting...doesn't happen to me on XP Pro or Win7 Pro.
Maybe XP PowerToys is at fault.....doesn't explain why SSMS is the only program that behaves this way though.quote:
Highlight and resize columns -- works for me just fine.
You're saying you can highlight several columns in a result grid, and re-sizeing one resizes them all? Not for me. What I would prefer is with several highlighted, double-clicking between any two of them would auto-resize all of them (like every other MS app does).ps: in "edit top 200 rows" views, I notice I can't even highlight a multiple columns to re-size.....must do it one at a time (hence why loss of ctrl-+ key is annoying).quote:
Double-click to expand nodes -- works for me just fine.
Lets say you're in the middle of list of 150 views and can't see the "Views" folder...where do you double click to collapse? In EM you clicked the vertical line that encompassed the whole folder...that line is now gone. So you have to scroll up to see "Views" then collapse it.Now I see numlock +/- does not do the collapsing as suggested...it collapses the current item, but not the parent folder. So it really takes "pick item, backspace, -", whereas EM was a single click action.quote:
Might check some of the options you have set.
I've looked up and down...hence finally posting the the call for help (or at least consolation). |
|
|
|
allpinball
Starting Member
4 Posts |
Posted - 2010-12-09 : 10:50:37
|
| OK.....shutting off "Activation follows mouse" in Power Toys fixed the stolen focus. I still don't understand why SSMS is the only app that seems to respond to this setting (hence why I thought it was a SSMS-caused thing). I guess we don't need to understand the cause, just the solution.Thanks for the confirmations / tips. |
|
|
|
|
|
|
|
|
SSMS annoyance - stolen focus - how to stop?