THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Andy Leonard

SSIS and ETL
Thoughts about Database and Software Development, and the tools of the trade.

SQL Server 2008 Management Studio - Function Keys

F7! 

The F7 key displays details in SSMS 2008. I'm almost positive SSMS 2005 RTM'd with the same funtionality and it was later removed.

F8? 

I love the F7 key. And I love that it displays details when I highlight something in Object Explorer - which, by the way, no longer displays when I press the F8 key... (grrr) - and then press the F7 key.

Functionitis

As a keyboard guy, I think it would be nice to have the Object Explorer display when I press F8 and Details display when I press F7. I'm sure there's a reason we don't have both in SSMS 2008, even if I don't know what that reason is.

I'm not starting an online petition to have it changed. I'll just work around it.

Multiple Mappings

I sometimes get myself in trouble with function keys.

A few weeks ago I was delivering SSIS training and attempted to demonstrate how you can remove all breakpoints in the Visual Studio 2005 IDE with Ctrl+Shift+F9. I pressed the key combination and it didn't work. Durnit!

I have Camtasia loaded on my presentation laptop. It just so happens Ctrl+Shift+F9 starts/stops recording via the Camtasia plug-in in PowerPoint. I recorded the remainder of the day.

:{> Andy


Published Friday, August 08, 2008 1:17 PM by andyleonard
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

AaronBertrand said:

Yes, I noticed the F8 functionality disappeared too.  You can use F8 to make it appear if it is currently closed, but you can not use F8 to make it disappear if it is currently open.

August 8, 2008 1:16 PM
 

andyleonard said:

Hi Aaron,

  I'm not able to use F8 with Developer Edition RTM. Maybe I'm doing something wrong?

:{> Andy

August 8, 2008 1:27 PM
 

AaronBertrand said:

Did you close Object Explorer first?  Where is the focus when you try hitting F8 (after you've closed Object Explorer)?  Are you on x86 or x64?

August 8, 2008 1:33 PM
 

andyleonard said:

Hi Aaron,

  I did close it first. I tried F8 with Object Browser closed and opened - no effect. I an currently testing the x86 version. I wonder if it's different in x64...

:{> Andy

August 8, 2008 1:37 PM
 

AaronBertrand said:

I am on Vista x86.  It opens with F8 when it is closed, but you can't toggle.  I will try it later on Server 2008 x64 and Server 2003 x86, and see if there are any differences in behavior.

August 8, 2008 1:51 PM
 

andyleonard said:

I'm running Windows Server 2008 x86 in VPC. That may be the difference... odd though that the OS would affect this...

Thanks for the help Aaron!

:{> Andy

August 8, 2008 1:59 PM
 

AaronBertrand said:

I spotted a couple of Connect items about this.  Here is one that seems like your issue, though Microsoft couldn't reproduce it:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=351585

And here is one that explains my issue (F8 has become an on-only switch, instead of an on-off toggle).  They were aware of it in 2006, and put it on the list for Katmai, but it wasn't addressed.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126902

August 8, 2008 2:02 PM
 

AaronBertrand said:

Maybe it is the VPC that is affecting it, not the operating system.  I am not using virtualization for any of the instances I've installed thus far.  (And maybe the other person who had this problem in RC0 was also experiencing this issue inside a virtual machine.)

August 8, 2008 2:04 PM
 

mrk said:

As a workaround to F8 not acting like a toggle for Object Browser window, you can close the Object Browser window using only the keyboard by hitting F8 to give it focus and Shift-Esc to close it.

August 11, 2008 3:59 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit

About andyleonard

Andy Leonard is a SQL Server MVP, database developer, engineer, husband, and father. Andy lives in Farmville Virginia with his lovely bride Christy Lynn and their three children: Stevie Ray, Emma Grace, and Riley Cooper. Andy's two older children - Manda and Penny - are grown and married. When he's not working (and Andy works a lot), he enjoys spending time with his family, working on their old farmhouse, fishing, and reading older sci-fi series.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement