SQL from another server underlined in red but works, can I remove the red underlines?

Question

_{Friday, September 16, 2016 1:55 PM}

Hi, I am using 2 different servers in this update, but in SSMS all references to [CHH-BI].[CommDB] are underlines in red. I tried refreshing the Intellisence Loacl Cache but still have this. The query works fine but it's annoying as it looks like the code has errors to address. I didn't set these databases up so can't change the design of them only report from them.

UPDATE [SLAMS_SQL].[dbo].[tblAEData] 
SET NHSNumber = d.NHSNo
FROM [SLAMS_SQL].[dbo].[tblAEData] as a
INNER JOIN [CHH-BI].[CommDB].[dbo].[tblDuplicateReg] as d ON  a.LocalPatientIdentifier COLLATE SQL_Latin1_General_CP1_CI_AS = d.[HEYNumber1]
    WHERE  a.LocalPatientIdentifier COLLATE SQL_Latin1_General_CP1_CI_AS = d.[HEYNumber1]
                        and a.NHSNumber IS NULL
                            and (d.[NHSNo] IS NOT NULL AND d.[NHSNo] NOT LIKE '%NHS%')

All replies (3)

_{Friday, September 16, 2016 2:00 PM}

Try to refresh:

CTR-Shift-R

_{Friday, September 16, 2016 2:11 PM}

Try to refresh:

CTR-Shift-R

I did mention I'd tried that buddy!

_{Friday, September 16, 2016 2:50 PM}

it is really annoying. Something similar when you are writing stuff in a Word document and the tool is correcting all the time. ctrl + q plus ctrl + i will remove red marks