New features added to SQL Prompt Watch now.

Synonym not always resolving

Hi,

In SQL-Prompt 10 (10.0.1.12389) when using a synonym the fields or the name of the synonym are not always resolved when there is no alias.



Kind regards,

Maurice
Tagged:

Answers

  • Hello @Maurice ,

    Thanks for reaching out and sorry that you're having trouble with SQL Prompt. I'm having a little trouble myself in trying to reproduce the issue. To clarify, is the alias called, "[PCD_NEDAP_RELATION]", actually an alias? If so, where is it defined? Also, can you kindly clarify how the synonym called "[dbo].[SE_PCD_NEDAP_RELATION]" relates to the alias that isn't being resolved? Would you mind sharing a sample script to assist in reproducing the issue that we can pass on to our development team for further review?


    Kind regards,


    Pete Ruiz
    Redgate Product Support
Sign In or Register to comment.