Prompt not showing synonyms

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

  bmrazik March 22, 2019 14:57

  - 0 +
• 
  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.

  Jessica R March 25, 2019 23:27

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

  SupiluliumaII September 06, 2019 11:14

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

  bmrazik September 06, 2019 14:36

  - 0 +
• 
  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?

  Jessica R September 06, 2019 23:11

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

  bmrazik September 07, 2019 14:22

  - 0 +
• 
  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.

  Jessica R September 09, 2019 19:50

  - 0 +
• 

  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 September 10, 2019 07:44

  - 0 +
• 

  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 September 10, 2019 07:45

  - 0 +
• 
  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! 
  

  SupiluliumaII October 03, 2019 07:41

  - 0 +

Add comment

Please sign in to leave a comment.