sql server 2000: Short cut for getting stored proc text

Question

Hi, what is the short cut to get entire text of the stored proc in query analyzer. I know that I could highlight table name and hit <alt><f1> and get the entire table structure.

Answer 1

It seems to not exist a shorcut with your exact request. If you want to see the complete list of query analyzer shorcuts visit the folowing link: http://msdn.microsoft.com/en-us/library/aa216992(SQL.80).aspx

Anyway you can modify, customize or create your own shorcuts. For examle ALT+F1 just executes the "sp_help" stored procedure. Check the documentation at:

http://msdn.microsoft.com/en-us/library/aa216956(SQL.80).aspx

Answer 2

You should be able to add a shortcut that uses sp_helptext, rather then sp_help