What are the challenges you face when working across database platforms? Take the survey
Options

Feature request - open stored procedute

joey666joey666 Posts: 6
edited September 6, 2007 6:37AM in SQL Prompt Previous Versions
Hi..

A thing I'd very much like would be a quick way to open an existing stored procedure / function ...

One way could be if I'd right click on a stored procedure name in SQL server Management Studio editor window, I'd be given an option to open the procedure in a new window.

Another way could be by pressing a hotkey and a window would popup containing all STPs, functions.... When starting typing, the list would be filtered. Choosing an item from the list would open the STP in another window.

Just my 2 cents :)

regards,
Martin

Comments

  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Hi Martin,


    Just type the following:

    ALTER PROC <procedurename>

    When you select your procedure from the drop-down the text will automatically be inserted into your query window. Also works for functions, views and triggers.

    Hope that helps.


    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Options
    Thanks for your reply, Bart.

    Its just not the way i want to use it :)

    When I edit an existing stored procedure and see that it
    makes a call to another procedure, it would be nice to have
    a quick way to open that procedure or function.

    Regards,
    Martin
  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    OK, now I understand. It's certainly something we'll consider for the future.
    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.