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

Metadata stops working after auto-open of sql-files

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.
Joelg
0

Comments

4 comments

Sort by
  • 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
    ostandage
    0
  • 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
    0
  • 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
    Joelg
    0
  • 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.
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.