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 Tuesday, July 15, 2008 10:03 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
bitbucket: I declare you "guilty" of not reading this thread! ;)

As stated by me and others before you have to be in a query window for this to work.

You have to highlight the text of the object name and then press Alt+F1.

Its a bad question maybe when we get to 15/08/2008 the poster will have corrected it :D

or better yet taken it down and reconsidered the whole concept.:D

:D:D:D:D:D

--Shaun


Hiding under a desk from SSIS Implemenation Work
Post #534529
Posted Tuesday, July 15, 2008 10:03 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: Friday, February 4, 2011 7:20 AM
Points: 977, Visits: 1,499
bitbucket (7/15/2008)
Hari.Sharma
Just select a table name and press Alt+F1 and see the result...

Using SSMS (SQL Express) pressed f8 to bring up object explorer. Selected a database (Northwind), then selected a table name in the object explorer window pressed Alt+F1, and nothing absolutely nothing happend

Using SSMS (Developer Edition) repeated above key strokes and nothing absolutely nothing happend


You have to have a query window open, and it must have the focus. You will get the sp_help results for the database of the selected object in Object Explorer.

Highlighting an object name that is spelled out in the query window will return sp_help for the object when the shortcut is used.


Tom Garth
Vertical Solutions

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Post #534530
Posted Tuesday, July 15, 2008 10:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 22, 2008 5:38 AM
Points: 4, Visits: 2
I have tried this with my Management Studio 2005.I select a table and then press alt + f1.It brings absolutely nothing.

what may the reason!
Post #534548
Posted Tuesday, July 15, 2008 11:13 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
I just tried this, and Alt+F1 did absolutely nothing that I could see in Management Studio. If it runs sp_help, it did so invisibly.

(Does this mean I have to wait till the date of the question for this to work? :) )

Edit: I just checked the article linked to, and it does not seem to have Alt+F1 in it. I searched for that string in the page, and it comes up with Ctrl+Alt+F1 (which does stuff in BOL), but nothing about Alt+F1.

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.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #534584
Posted Tuesday, July 15, 2008 12:41 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:28 PM
Points: 2,607, Visits: 17,926
Cool. I like it. I'll be using this frequently to quickly double check column types or foreign keys while writing scripts. Very handy, thanks!

Thanks,
Chad
Post #534673
Posted Tuesday, July 15, 2008 2:16 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:37 PM
Points: 33,189, Visits: 15,329
OK, I accidentally marked this as published instead of pending. I'll remove all answers, and you can re-do this one on the 15th.

I guess it made sense to me. I just brought up a query window and tried it, but I can see why you would think that it was an Object Explorer thing. I'll reword the question.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #534742
Posted Tuesday, July 15, 2008 6:14 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 4:33 PM
Points: 282, Visits: 117
I did try it. Even though the keyboard had defaults setting. I hope the attached details does show the difference. Keyboard shortcuts can be customised and I usually change the defaults to my liking however, I had reverted to default setting before trying it.

  Post Attachments 
sp_help_vs_AltF1.doc (15 views, 198.00 KB)
Post #534824
Posted Wednesday, July 16, 2008 3:21 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
Jamie Longstreet (7/16/2008)
I was recently at a SQL Server Users Group where some of the users had never seen that you can highlight a portion of text and run it. I was shocked because I learned it early on. Maybe the problem with the question is that not everyone instantly jumps into the SQL Manager, pastes code and runs with it.


Thats wild!

You mean people didn't read the book/readme.txt/(fxxxing) manual/wiki/knowledge base/help... :D previous posts :D ...?

Now why am I not shocked? :D


Hiding under a desk from SSIS Implemenation Work
Post #535022
Posted Wednesday, July 16, 2008 5:17 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, August 21, 2014 3:52 PM
Points: 5,988, Visits: 12,923
I only answered this so I could jump a month into the future and thus be on holiday.

---------------------------------------------------------------------

Post #535093
Posted Wednesday, July 16, 2008 7:37 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, August 22, 2014 7:04 AM
Points: 3,673, Visits: 72,433
george sibbald (7/16/2008)
I only answered this so I could jump a month into the future and thus be on holiday.


Me too :)




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #535186
« Prev Topic | Next Topic »

Add to briefcase «««23456»»»

Permissions Expand / Collapse