title: Why do I get "Synonym 'syn.Syn_AAA' refers to an invalid object" Error?
body: <p>When I execute a stroed procedure it works. But specifically when I run the select statement I get the following error</p>
  
  <blockquote>
    <p>Synonym 'syn.Syn_NEO_DB_tGradeAliases' refers to an invalid object.</p>
  </blockquote>
  
  <pre><code>SELECT  
              aa.CompanyId [LegCompanyId],
              aa.ProductId AS [LegGradeId],
              aa.GradeAliasId [LegGradeAliasId],
              aa.ProductName AS [LobGradeText],
              aa.[Alias] [GradeAlias],
              aa.PhraseKey [PhraseKey],
              GETUTCDATE() AS 'TimeStamp'
      FROM    syn.Syn_AAA aa
  </code></pre>
  
  <p>I haven't done any database change/permission change.
  How can I overcome this?</p>
  
  <p>I ran following query and it shows the base_object_name correctly linked to my table.</p>
  
  <blockquote>
    <p>SELECT *  FROM sys.synonyms WHERE name = 'Syn_AAA'</p>
  </blockquote>