bitbucket (7/15/2008)
Hari.SharmaJust 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.