title: SQL71501 - How to get rid of this error?
body: <p>We're using two schemas in our project (<code>dbo</code> + <code>kal</code>).</p>
  
  <p>When we are trying to create a view with the following SQL statement, Visual Studio shows as an error in the error list.</p>
  
  <pre><code>CREATE VIEW [dbo].[RechenketteFuerAbkommenOderLieferantenView]
  AS
      SELECT
          r.Id as RechenkettenId,
          r.AbkommenId,
          r.LieferantId,
          rTerm.GueltigVon,
          rTerm.GueltigBis,
          rs.Bezeichnung,
          rs.As400Name
      FROM
          [kal].[Rechenkette] r
      JOIN
          [kal].[RechenketteTerm] rTerm ON rTerm.RechenketteId = r.Id
      JOIN
          [kal].[Basisrechenkette] br ON rTerm.BasisrechenketteId = br.Id
      JOIN
          [kal].[Rechenkettenschema] rs ON rs.Id = br.Id
      WHERE 
          r.RechenkettenTyp = 0
  </code></pre>
  
  <p>The error message looks like this:</p>
  
  <blockquote>
    <p>SQL71501: Computed Column: [dbo].[RechenketteFuerAbkommenOderLieferantenView].[AbkommenId] 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:<br>
    [kal].[Basisrechenkette].[r]::[AbkommenId], [kal].[Rechenkette].[AbkommenId], [kal].[Rechenkette].[r]::[AbkommenId], [kal].[Rechenkettenschema].[r]::[AbkommenId] or [kal].[RechenketteTerm].[r]::[AbkommenId].</p>
  </blockquote>
  
  <p>Publishing the view and working is just fine, but its quite annoying to see the error message all the time when building our project having all the serious errors get lost in the shuffle of those sql errors.</p>
  
  <p>Do you have any idea, what the problem might be?</p>