July 14, 2008 at 1:11 pm
Comments posted to this topic are about the item Short cut key
July 14, 2008 at 1:37 pm
Did anyone else notice the date for this QOTD is a month in the future?
Doc Brown rules!
:blink:
July 14, 2008 at 3:09 pm
I'm fairly new to SQL Server so I may not be seeing it. ALT+F1 brings up nothing at all in management studio. Also, isn't sp_help used in code?
:unsure:
July 14, 2008 at 8:24 pm
The link "SQL Server Management Studio Keyboard Shortcuts" is very helpful.
July 14, 2008 at 9:31 pm
Alt+F1 acts a little different to sp_help. sp_help list specifics for an object while Alt+F1 list all objects in a selected database.
July 14, 2008 at 11:28 pm
Karl_Chand (7/14/2008)
Alt+F1 acts a little different to sp_help. sp_help list specifics for an object while Alt+F1 list all objects in a selected database.
Did you really try this?
Just select a table name and press Alt+F1 and see the result...
July 14, 2008 at 11:49 pm
Even though my Studio is set up for the shortcut, it doesn't do anything. Most probably because I've got a soft-KVM and that seems to blat most shortcuts just because it can. 😉
I'll have to try it at home.
July 14, 2008 at 11:55 pm
I don't have SQL Server 2005 so I can't test, but according to the keyboard shortcut list on BOL (http://msdn.microsoft.com/en-us/library/ms174205.aspx) there is no ALT+F1 at all. Is this a custom keyboard shortcut?
July 15, 2008 at 2:08 am
Hari.Sharma (7/14/2008)
Did you really try this?
Just select a table name and press Alt+F1 and see the result...
Just select a table name and press Alt+F1, is that all I have to do? I click on a table name in the object explorer and pressed Alt+F1 and nothing happened, so I made a new query and put the table name in there (with and without the database name), and I received an error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'.
So what do I need to do to see this? Does doing this in Management Studio Express 2005 not work?
PS. I see I wasn't the only one to confuse this with the "How Do I" under Help on the toolbar :hehe:
EDIT:
Why is this QOTD for next month anyway? I know there is a question for this month, and that would have something to do with it.
July 15, 2008 at 2:25 am
You have to enclose the object name in double-quotes when using two-part names (include schema)..
like this : "dbo.spt_values" (in master).
July 15, 2008 at 2:48 am
As simple as it is:
-- Query
USE [MyDataBase]
GO
TableName -- Bold shows that it is selected
-- Now Press Alt+F1
I think it is very easy and self explanatory.
See the attachment
July 15, 2008 at 4:20 am
Yeah so if I got it wrong cos I obviously havent answered it yet as that would be next month can i have the point back til 15th August and then lose it? 😀
This question is very poor in explanation of what it is asking, like when would you push the help button combo i.e. within a query window or within object explorer?
The QOTD posters should know what pedants we all are - precision is key ambiguity leads to hell 😀
--Shaun
Hiding under a desk from SSIS Implemenation Work :crazy:
July 15, 2008 at 5:48 am
Hari.Sharma (7/15/2008)
As simple as it is:-- Query
USE [MyDataBase]
GO
TableName -- Bold shows that it is selected
-- Now Press Alt+F1
I think it is very easy and self explanatory.
See the attachment
Tried that and still got the same error. However, if I removed dbo from the table name, it worked.
Learnt something new, and still earned a point 😎
July 15, 2008 at 5:57 am
I dont know the reason but it is working on my system without removing dbo 😎
July 15, 2008 at 6:37 am
Well it sure doesn't work by default. I tried it in 2005 and 2008 and received nothing. I also note, that the answer, ALT-F1, is not listed in the documentation linked to. I'm calling shenanigans on this one.
----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
The Scary DBA Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software
Viewing 15 posts - 1 through 15 (of 51 total)
You must be logged in to reply to this topic. Login to reply