Prompt not showing synonyms

bmrazik

after upgrading to the latest version of prompt, i'm now unable to see definitions of synonyms when hovering over the object name in my scripts...i checked options to see if something had been unchecked that would do this, however, i found nothing...any ideas what i can do to get this feature back to working?

bmrazik

it also appears to have removed the definition for indexes on indexed views

Jessica R

Hi @bmrazik,

Thanks for your post!

I believe we have a ticket open with you on this, #133888. We will work with you through the ticket and will post here once we have an update.

SupiluliumaII

It's been almost half a year - is there any progress on this issue?

bmrazik

no...i've reverted to an older version of prompt...i mistakenly updated once recently and the same issues occurred

Jessica R

Sorry to hear you're both still running into this!

To help us narrow down where things are going wrong, can I just confirm:
- Does this fail for every synonym?
- Does it fail in every query, even a simple one that calls on the synonym?

bmrazik

yes, all synonyms no matter the query...you'll see above as well, that i lose peeking at index definitions on indexed views

Jessica R

Thanks for confirming that, @bmrazik!

We unfortunately still can't reproduce this locally, so we'll need to get more details to understand what's causing it in certain environments. I've opened a follow up ticket for you, #145610, and will work with you there!

@SupiluliumaII, if you have a supported license please feel free to open a ticket as well b y emailing support@red-gate.com. Otherwise, I'll update here once we know more.

SupiluliumaII

Jessica R said:

Sorry to hear you're both still running into this!

To help us narrow down where things are going wrong, can I just confirm:
- Does this fail for every synonym?
- Does it fail in every query, even a simple one that calls on the synonym?

bmrazik said:

yes, all synonyms no matter the query...you'll see above as well, that i lose peeking at index definitions on indexed views

Same here. I see no synonyms at all in suggestions, even in very simple queries. Peeking at synonyms' definitions does not work either.

SupiluliumaII

Jessica R said:

@SupiluliumaII, if you have a supported license please feel free to open a ticket as well b y emailing support@red-gate.com. Otherwise, I'll update here once we know more.

@Jessica R, thanks for the suggestion, I will do that.

SupiluliumaII

FYI, they fixed this in version 9.5.20.11737.
https://documentation.red-gate.com/sp9/release-notes-and-other-versions/sql-prompt-9-5-release-notes#SQLPrompt9.5releasenotes-9.5.20.11737
Thanks Redgate!