title: Database Schema Ambiguous Index Hint Issue
body: <p>I've just been importing a database to my Visual Studio Project using the Sql Server 2008 Database Project. After resolving many issues highlighted by Visual Studio i am now left with just 2 both relating to hinting index's. The 2 warnings (with the causing statements) are</p>
  
  <pre><code>SELECT a.FI, a.GD 
  FROM [RME].[dbo].[BP_RN] a with(index(idx_GD))
  WHERE GD.STWithin(@Geometry) = 1
  </code></pre>
  
  <blockquote>
    <p>SQL04151: Procedure: [dbo].[sp_TNFRME]
    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:
    [dbo].[BP_RN].[idx_GD] or
    [dbo].[idx_GD].</p>
  </blockquote>
  
  <p>and </p>
  
  <pre><code>SELECT a.I
  FROM [dbo].[N] a with(index(idx_G))
  WHERE a.G.STIntersects(@Geometry) = 1
  </code></pre>
  
  <blockquote>
    <p>SQL04151: Procedure: [dbo].[sp_DIOQE]
    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: [dbo].[idx_G] or
    [dbo].[N].[idx_G].</p>
  </blockquote>
  
  <p>The reason i have listed both seperatly is because the first is querying a seperate database and i wasn't sure if this means it needs to be resolved in a different way.</p>
  
  <p>Anyway my question is how do I resolve this error or fully qualify the hint so it is no longer ambiguous?</p>
  
  <p>Thanks</p>