Navigating Via Keyboard In SQL Server 2005 1

[jonbatts]

Simple question. In Microsoft SQL Server Management Studio Express SQL Server 2005, I haven't figured out how to use the menus to open and modify objects. In Enterprise Manager I could give focus to a table and use ALT - A - O - A to open all rows in that table. In 2005, I have to use a right click and select Open Table. How can I do this with the menus using my keyboard? Thanks, and have a great day.

 

[mrdenny]

To do this you would have to hit the right click key on the keyboard (usually between ALT and CTRL on the right hand side of the keyboard). Then hit what ever key has the underscore. If the underscores aren't shown (I've got SQL 2008 install and they aren't on my build) then start with the first letter and work your way down the list. If there is a hot key setup you'll find it this way.

The options on the right click menu don't appear in any of the regular drop down menus in the UI.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[jonbatts]

Mrdenny, thanks for your help. This works when I'm using a standard keyboard, but there's no right click button on my laptop. Any other ideas?

 

[mrdenny]

You can try using a keyboard mapping tool (I don't know of any off hand) to map the key. Without the right click key you won't have much luck. Maybe it's a function key or something?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[jonbatts]

I'm assuming there's no way to get these shortcuts to show up in the menu since noone has yet posted it. I don't understand why Microsoft would take away the ability to perform operations via keyboard adn the menu, and force us to use the mouse to accomplish these tasks. If the answer just hasn't been pointed out yet, I'd love to hear it. Thanks for your help guys.

 

[JustinEzequiel]

Shift+F10 pops up the context menu

 

[jonbatts]

Thanks Justin! Looks like Shift+F10 is a right click in Windows. Still find it silly that this is lacking in the menu, but this will work. Thanks again.