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

Feature Request: ALTER Object behaviour

TOftringTOftring Posts: 10
edited July 17, 2007 12:44PM in SQL Prompt Previous Versions

we bought SQL Prompt for our company. It`s a very cool tool ;-). But we have one suggestion.

The feature to edit a procedure or a function by autocompletion with the tab key is genious but has one little mistake:

ALTER PROCEDURE --> Tab is a great thing but would it be possible that SQL Prompt checks if there is a newer version of the procedure in the SQL Server than in the SQL Prompt cache. In the moment it is necessary to change the database or to refresh the cache before editing the procedure.

The same thing for functions.



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

    Thanks for posting. It's something we'll consider for the future. The new version of SQL Prompt (3.5) has a shortcut for refreshing the cache without needing to open the Cache Management dialog. I'll be announcing the availability of the 3.5 release candidate within the next 24 hours so you might want to give that a whirl.

    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.