Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456»»

Short cut key Expand / Collapse
Author
Message
Posted Thursday, July 17, 2008 8:07 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 8, 2009 1:32 AM
Points: 129, Visits: 35
GSquared (7/15/2008)

The Tools\Options window in Management Studio says that Alt+F1 runs sp_help. I tried a few options. If I select an object in the object explorer window, it does absolutely nothing. If I open a connection to a specific database, make sure that the connection's window has the focus, and then hit Alt+F1, it will run sp_help for the database, but not for a proc that I have selected in the object explorer window.

So, yeah, it will do what the question says. Sort of. Under limited circumstances. And not in a particularly useful fashion. But it does do it.

Others have found the same thing, obviously.


I also noticed that: it's looking for objects it can see using the query window connection, not those selected on the object explorer...
Anyway it's a nice trick to know, even if I answered it the wrong way this QOTD :D
Post #536019
Posted Monday, July 21, 2008 3:21 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,403, Visits: 1,400
Sure I was surprised with date on the QOD. Is there any specific reason for this?


Post #537490
Posted Friday, August 1, 2008 2:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 24, 2008 1:27 PM
Points: 350, Visits: 229
I wonder what will happen when August 15th comes around :D.
Post #544919
Posted Friday, August 1, 2008 2:58 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, October 4, 2012 9:20 AM
Points: 583, Visits: 1,060
It will just be SSDD :D

Hiding under a desk from SSIS Implemenation Work
Post #544920
Posted Monday, August 11, 2008 8:10 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, July 10, 2014 1:33 PM
Points: 457, Visits: 476
This seems to be configuration specific. I don't know who originally set up my SQL Server Management Studio on my PC, but when I am in a query and either highlight the whole query or just the table name in the FROM using Alt+F1, I get a bunch of meta-data on the structure of the table. I get syntax errors highlighting anything else. However, when I highlight something like a function name and use Shift+F1, I am taken to a help screen for the function highlighted. Thus I should get credit for answering Shift+F1, except that as I said it must be configuration specific and highly modifiable from one machine to another.

What is really weird about this is I just went into my Tools-options page and saw that my keyboard settings for the Alt+F1 key are still set to "sp-help", with no other settings for Shift+F1. It seems something somewhere else is over riding the Tools Options Keyboard settings in Management Studio . . . hmmmm!


Ron K.

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
Post #550277
Posted Friday, August 15, 2008 4:09 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 24, 2008 1:27 PM
Points: 350, Visits: 229
skyline666 (8/1/2008)
I wonder what will happen when August 15th comes around :D.


Well thats what happened, the QOTD for today is in fact this one .
Post #553324
Posted Friday, August 15, 2008 4:33 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, October 4, 2012 9:20 AM
Points: 583, Visits: 1,060
Damn I got it wrong again! :D

Hiding under a desk from SSIS Implemenation Work
Post #553332
Posted Friday, August 15, 2008 4:39 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 24, 2008 1:27 PM
Points: 350, Visits: 229
Shaun McGuile (8/15/2008)
Damn I got it wrong again! :D


Whoops! Don't worry though, when I answered it the first time last month I got it wrong, and then the answers were reset, and guess what ... the idiot that I am, I actually picked the same wrong answer, doh!
Post #553338
Posted Friday, August 15, 2008 4:44 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, October 4, 2012 9:20 AM
Points: 583, Visits: 1,060
skyline666 (8/15/2008)
Shaun McGuile (8/15/2008)
Damn I got it wrong again! :D


Whoops! Don't worry though, when I answered it the first time last month I got it wrong, and then the answers were reset, and guess what ... the idiot that I am, I actually picked the same wrong answer, doh!


Same here :D


Hiding under a desk from SSIS Implemenation Work
Post #553339
Posted Friday, August 15, 2008 7:20 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 7:01 AM
Points: 999, Visits: 8,658
Well, not having Management Studio yet, I checked Microsoft's list of keyboard shortcuts for SQL Server at http://technet.microsoft.com/en-us/library/ms174205.aspx. There is no sp_help listed on the page at all, so I checked each of the answers. There is no Alt-F1 listed on the page, either. So, answered that there is no keyboard shortcut.



Steve Eckhart
Post #553446
« Prev Topic | Next Topic »

Add to briefcase «««23456»»

Permissions Expand / Collapse