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

Newly created database not cached

I created a new database on a server which has multiple databases, all of which have their cache included properly in the Cache Management screen.

The newly created database does not appear in this list, nor does SQL Prompt attempt to build the cache when I connect to this database. I even went so far as to create a new connection to force this, but this does not work either.

I'm running the latest version.

Can you help?
TomT
0

Comments

5 comments

Sort by
  • TomT
    Will anyone be answering me on this?
    TomT
    0
  • Brian Donahue
    Hi Tom,

    Sorry about the delay. If the software is operating normally, than the only way this could happen is if you include the database in the list of databases to ignore in the options (Connections tab).

    Otherwise it's hard to say. SQL Prompt doesn't have any debugging or tracing capabilities that could help. Maybe starting a SQL Profiler session to trace the connection to that particular database when SQL Prompt is supposed to connect to it may releal the cause of the problem.
    Brian Donahue
    0
  • Bart Read
    Hi there,


    Thanks for posting. There's a bug that means in the same session it doesn't always refresh its own database list. If you restart your editor you should find it works fine.


    Cheers,
    Bart
    Bart Read
    0
  • Brian Donahue
    Hi,

    Thanks, Bart, for the assist! :-)
    Brian Donahue
    0
  • TomT
    Bart Read wrote:
    Hi there,


    Thanks for posting. There's a bug that means in the same session it doesn't always refresh its own database list. If you restart your editor you should find it works fine.


    Cheers,
    Bart

    Thanks Bart, I'll give that a try.
    TomT
    0

Add comment

Please sign in to leave a comment.