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

Copy to clipbord copies from cache!

I just discovered a very dangerous "feature":

If I type part of a name of a stored procedure, a button "Copy to clipboard" appears on the popup window.
If I copy the procedure code to clipbord with this button, the code is retrieved from cache, which may be outdated.

This feature would be very handy to avoid searching a specific procedure in the object browser of query analyzer. However, I would expect SQL Prompt to retrieve the acutal code from the database. I accidenty discovered that this is not the case, which is very dangerous when the copied code is used to make modifications!

Regards
Ulrich
Ulrich
0

Comments

1 comment

Sort by
  • Lionel
    Hi

    You are right that prompt pulls down all metadata when you connect for the first time and then just uses this cached data. This is not going change for this version but we are clearly suffering some of the limitations of this model so we will look at replacing it in the next version.

    Lionel
    Lionel
    0

Add comment

Please sign in to leave a comment.