Menu
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
821
Using SQL Server Management StudioExpand Databases, expand the database in which the procedure belongs, and then expand Programmability. Expand Stored Procedures, right-click the procedure and then select Script Stored Procedure as, and then select one of the following: Create To, Alter To, or Drop and Create To.
In SQL Server Management Studio, first connect to the Database Engine. Next, under Object Explorer, expand the database in which you have created a procedure, and then expand “Programmability” option. Next, expand “Stored Procedures”, right-click the procedure you want and then select “Properties” option.
Execute Scripts in SQL Server Management Studio If you want to parse all the scripts without executing them in the current query window, simply press CTRL+F5 or you can select some lines of code to be parsed then press CTRL+F5.
You can find the stored procedure in the Object Explorer, under Programmability > Stored Procedures as shown in the following picture: Sometimes, you need to click the Refresh button to manually update the database objects in the Object Explorer.
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.
91
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:
F8 - Open Object Explorer
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
28
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
