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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 1 through 15 (of 51 total)
You must be logged in to reply to this topic. Login to reply