Metadata stops working after auto-open of sql-files

Joelg

When opening management studio, previously opened files are automatically opened. 
Since a couple of weeks, these files will contain a lot of squiggly red lines. Existing objects are not recognized, nor hoverable. I see "invalid object name [existing table name]" for tables that exist.
refreshing cache (ctrl+shift+d) does nothing, it also is extremely fast, usually takes a couple of seconds.

If i save the file, close it and re-open it, the redgate cache starts working.

ostandage

Hi, 

I'm sorry to hear you are experiencing difficulty with SQL Prompt.

Please could you confirm which version of SQL Prompt and Management Studio you are using? 

Thanks, 

Owen

Joelg

Hi! Thanks for your response

These are the versions at the moment.
I will try to reproduce after updating ssms and prompt.
/Joel

SQL Server Management Studio 15.0.18330.0

SQL Server Management Objects (SMO) 16.100.37971.0

Microsoft Analysis Services Client Tools 15.0.19040.0

Microsoft Data Access Components (MDAC) 10.0.17763.1

Microsoft MSXML 3.0 6.0 

Microsoft .NET Framework 4.0.30319.42000

Operating System 10.0.17763

Joelg

Could reproduce on the following versions

SQL Server Management Studio 15.0.18338.0

SQL Server Management Objects (SMO) 16.100.41011.9

Microsoft Analysis Services Client Tools 15.0.19205.0

Microsoft Data Access Components (MDAC) 10.0.17763.1

Microsoft MSXML 3.0 6.0 

Microsoft .NET Framework 4.0.30319.42000

Operating System 10.0.17763

Tianjiao_Li

Hi @Joelg,

The squiggly red lines are actually from SSMS rather than SQL Prompt. 

I'll reach out shortly by email so that we can take a deeper look at the issue for you.