What is the keyboard shortcut to view a SQL Server 2005 (Management Studio) stored procedure

Question

I heard that there is a keyboard short cut to bring up the code of a SQL Server 2005 (Management Studio) stored procedure. This key combination would do the same function as sp_helptext.

This may only be an Urban Legend.

Thanks

Answer 1

The first thing I do after installing management studio on a new machine is to set sp_helptext to be CTL+F1 in management studio.

Tools / Options / Environment / Keyboard / Ctrl-F1 == sp_helptext

Then, i can highlight any view, stored proc, function, whatever - and press CTL-F1 and get the text of the object in my results window. Not sure if this is exactly what you're looking for, but it definitely helps me to be more productive in the query windows.

Answer 2

Just using the Ctrl + F1 for the first time it works well & displays the SP in the results grid.

Shortcut hotkey combination to view the code of an SP can also be done by the following:

1. F8 - Open Object Explorer

2. Arrow keys down to SP

3 Right Click (usually located between right windows key & right ctrl key)

4 Y - press Y which will select Modify

5 New Query Window opens with alter SP code

Hope this helps