If in Query Analyzer I clear the cache using the "Clear Cache" button the cache is not re-generated for the current session. I had to select the database from the drop down list for the cache to be generated.
sangha
0

Comments

4 comments

  • sangha
    Also when I type "SELECT * FROM " and press CTRL+SPACEBAR "All common objects" is selected by selected by default.
    The problem here is that "All common objects" is disabled and should not be selected.
    sangha
    0
  • Tilman
    Hi,
    If in Query Analyzer I clear the cache using the "Clear Cache" button the cache is not re-generated for the current session. I had to select the database from the drop down list for the cache to be generated.

    The current functionality is just a make-shift solution for the beta. See release notes.
    Also when I type "SELECT * FROM " and press CTRL+SPACEBAR "All common objects" is selected by selected by default.
    The problem here is that "All common objects" is disabled and should not be selected.

    I'm not sure what you mean. I have snippets and T-SQL keywords on the All common objects list, i.e. it isn't disabled.

    Regards,

    Tilman
    Tilman
    0
  • sangha
    Tilman wrote:
    Also when I type "SELECT * FROM " and press CTRL+SPACEBAR "All common objects" is selected by selected by default.
    The problem here is that "All common objects" is disabled and should not be selected.

    I'm not sure what you mean. I have snippets and T-SQL keywords on the All common objects list, i.e. it isn't disabled.

    It happens after your clear the cache. Cache is not generated and this causes "All common objects" when you type "SELECT * FROM " and press CTRL+SPACEBAR.
    Did you type "SELECT * FROM ". You do not get snippets and T-SQL keywords when you type "SELECT * FROM " and press CTRL+SPACEBAR.
    I can upload a pic. If required let me know where to upload.
    sangha
    0
  • Tilman
    Sorry, my bad. I ignored the fact that it was after "SELECT * FROM ". I'll add it to the list.

    Thanks,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.