What are the challenges you face when working across database platforms? Take the survey

SQL Prompt Format removes alias causing ambiguous error

when I use Format SQL (using a custom style) on a stored proc,  a parameter to a User-Defined Function changes from [c].[ID] to [ID] and when I compile get the error "Ambiguous column name 'ID'.".  The strange thing is this only happens on production server which is the exact same SQL version as DEV and QA.  So I am thinking is this somehow permission related?  I can send you the stored proc and the custom format style file if needed.  The SQL Server version is:  Microsoft SQL Server 2012 (SP4-GDR) (KB4057116) - 11.0.7462.6 (X64) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)


  • Options
    I have the same issue, and have reported it as a bug.  Unfortunately, even though I have sent RG code samples they have not been able to reproduce.  I have been told that this has been kicked up to their development team.
Sign In or Register to comment.