title: SQL71561 error - ambiguous reference
body: <pre><code>Error   431 SQL71561: 
  Computed Column: [dbo].[ViewAlertFrequency].[BeginDate] contains an unresolved 
  reference to an object. 
  Either the object does not exist or the reference is ambiguous because it could 
  refer to any of the following objects: 
  [Lookup].[dbo].[AlertFrequency].[AlertFrequency]::[BeginDate] 
  or [Lookup].[dbo].[AlertFrequency].[BeginDate]  
  </code></pre>
  
  <p>The current database is Lookup, so there shouldn't be any issues finding this object. This is imported from an existing view. It appears that the whole database is like this. I'm not sure what the :: syntax is.</p>
  
  <p>Here is the view:</p>
  
  <pre><code>CREATE VIEW [dbo].[ViewAlertFrequency]
  
  AS
  
  --###
  --ViewAlertFrequency
  --###
  
  --###
  --used by: eobResolve
  --###
  
  SELECT DISTINCT TOP 100
      AlertFrequency.[ID]     AS [ID],
      AlertFrequency.Code     AS Code,
      AlertFrequency.[Name]       AS [Name],
      AlertFrequency.[Description]    AS [Description],
      AlertFrequency.[Rank]       AS [Rank],
      AlertFrequency.BeginDate    AS BeginDate,
      AlertFrequency.EndDate      AS EndDate
  
  FROM         
      Lookup.dbo.AlertFrequency   AS AlertFrequency
  
  ORDER BY
      AlertFrequency.[Rank]       ASC
  
  
  GO
  GRANT SELECT
      ON OBJECT::[dbo].[ViewAlertFrequency] TO [eobResolve]
      AS [dbo];
  </code></pre>