How can we help you today? How can we help you today?

New Stored Procedures are not included as candidates

Hi guys,

First of all I've been waiting for a tool like this a long time - great work! :wink:

However, I'm confused about the fact that my own added stored procedures are not included as candidates - only the system SP's are displayed. For instance, executing this statement in the Enterprise Query Analyzer:

CREATE PROCEDURE spMyProcedure AS SELECT * FROM tblA

saves a new store procedure which pops up in the explore panel on the left. Typing EXECUTE and space displays the list, but "spMyProcedure" is not included. If i ignore the list and just type in:

EXECUTE spMyProcedure

it works fine. Does anyone know why?
boomshanka
0

Comments

4 comments

Sort by
  • Tilman
    Hi,

    You have to refresh SQL Prompt's cache every time you change the schema; SQL Prompt doesn't know about the changes, otherwise. To refresh the cache go to the Options dialog (via the system tray icon) and click 'Clear cache'. The next you use SQL Prompt it will cache the database schema again.

    Hope that helps,

    Tilman
    Tilman
    0
  • boomshanka
    Great, thanks!

    Do you know if there is a keyboard shortcut for clearing the cache?
    boomshanka
    0
  • brammp
    I would like the option to have SQL Prompt clear its cache everytime at startup. That way, I don't have to manually clear it.

    Phil
    brammp
    0
  • Tilman
    Hi,
    Do you know if there is a keyboard shortcut for clearing the cache?

    Not in version 2, we will add one for version 3.
    I would like the option to have SQL Prompt clear its cache everytime at startup. That way, I don't have to manually clear it.

    I will add it to our list.

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.