Brian Donahue wrote:Hi Michael,
I think it would help to clarify two points:
- Refreshing suggestions applies only to the database to which you are currently connected.
- SQL Prompt automatically refreshes a database's objects when you close down your query editor application, then re-open it and re-connect to that database.
CodantiM wrote:I just confirmed that disabling SQL Prompt and re-enabling it causes it to refresh a portion of the cache.
It appears to clear the cache for the connected server, but not for linked servers. i.e. I was creating a query in DB1 that referenced tables in DB2, I added a table to DB2 and SQL Prompt didn't see it. After a disable/enable cycle SQL Prompt saw it.
On the other hand it didn't make SQL Prompt refresh the cache from a linked server DB, so it is only a partial solution. It appears the only way to completely refresh the cache is to restart SSMS.
Users browsing this forum: No registered users and 1 guest