SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Short cut key


Short cut key

Author
Message
luca.pierobon
luca.pierobon
SSC-Enthusiastic
SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)

Group: General Forum Members
Points: 131 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 BigGrin
Anipaul
Anipaul
SSCrazy Eights
SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)

Group: General Forum Members
Points: 9923 Visits: 1407
Sure I was surprised with date on the QOD. Is there any specific reason for this?



skyline666
skyline666
Mr or Mrs. 500
Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)

Group: General Forum Members
Points: 524 Visits: 229
I wonder what will happen when August 15th comes around BigGrin.
Shaun McGuile
Shaun McGuile
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1133 Visits: 1060
It will just be SSDD BigGrin

Hiding under a desk from SSIS Implemenation Work Crazy
Ron Kunce
Ron Kunce
SSC Eights!
SSC Eights! (840 reputation)SSC Eights! (840 reputation)SSC Eights! (840 reputation)SSC Eights! (840 reputation)SSC Eights! (840 reputation)SSC Eights! (840 reputation)SSC Eights! (840 reputation)SSC Eights! (840 reputation)

Group: General Forum Members
Points: 840 Visits: 496
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
skyline666
skyline666
Mr or Mrs. 500
Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)

Group: General Forum Members
Points: 524 Visits: 229
skyline666 (8/1/2008)
I wonder what will happen when August 15th comes around BigGrin.


Well thats what happened, the QOTD for today is in fact this one Hehe.
Shaun McGuile
Shaun McGuile
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1133 Visits: 1060
Damn I got it wrong again! BigGrin

Hiding under a desk from SSIS Implemenation Work Crazy
skyline666
skyline666
Mr or Mrs. 500
Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)

Group: General Forum Members
Points: 524 Visits: 229
Shaun McGuile (8/15/2008)
Damn I got it wrong again! BigGrin


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!
Shaun McGuile
Shaun McGuile
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1133 Visits: 1060
skyline666 (8/15/2008)
Shaun McGuile (8/15/2008)
Damn I got it wrong again! BigGrin


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 BigGrin

Hiding under a desk from SSIS Implemenation Work Crazy
Steve Eckhart
Steve Eckhart
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1234 Visits: 8664
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search