How can we help you today?

How can we help you today?

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.

Image: /hc/user_images/01JKDB3CMZ41GPWVN2VQGJNSXZ.png

Kind regards,

Maurice

Maurice November 14, 2019 13:23

0

Comments

1 comment

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

Pete_Ruiz November 15, 2019 19:00

0

Add comment

Please sign in to leave a comment.