Newly created database not cached

TomT

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

Will anyone be answering me on this?

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.

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

Brian Donahue

Hi,

Thanks, Bart, for the assist! :-)

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.