Why is it not possible to validate object names from linked servers?

Jan88

All columns get this red line like something is wrong, since it comes from a linked server. From my point of view a good point to improve the software. ;-)


Can you provide a bug fix for this case?
Best greetings from Germany,
Jan

Russell D

Depending on what version you're using there is an issue in Prompt to do with Linked Servers. If you're using the latest I'd advise downgrading to https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.4.14.8687.exe and waiting until the next release where we've fixed this behaviour.

Jan88

Hi Russell, thank you very much for your fast reply. :-D Yes, I use the last version and I will follow you hint with downgrading. I will comment on it if it is working and I'm happy to know that this bug is known so it can be fixed in the next version. 
Sincerely
Jan

Jan88

Russell D said:

Depending on what version you're using there is an issue in Prompt to do with Linked Servers. If you're using the latest I'd advise downgrading to https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.4.14.8687.exe and waiting until the next release where we've fixed this behaviour.

Hi Russell, no I did the downgrade and the issue is the same. At least the function tab after select * provides now the column names and solve it.