Display the text of the stored procedure in SQL Query Analyzer

Posted on March 21, 2007. Filed under: Uncategorized |

Ever wanted to just quickly check the stored procedure logic from the SQL Query Analyzer. Here is how you do it,

Open your SQL Query Analyzer
Get to “Tools >> Customize”
Navigate to the “Custom” tab
Pick a shortcut key that’s available (for example, Ctrl + 3)
Type this on the Stored Procedure field “sp_helptext” (without the quotes, of course)
Hit Ok

Then, open up a new query window and hit Ctrl + T keys to display the output in text format. Type the name of the stored procedure. Block to select the stored procedure name and hit the shortcut key that you’ve configured above. You should be able to see the stored procedure text on your output window. This would be handy if you really, quickly wanna’ peak at the logic of a stored procedure and don’t want to open up an Alter window for that.

tags: SQL, SQL Query Analyzer, Stored Procedures, Tips and Tricks, Tools, Handy Tips