title: Sql Server management studio "Invalid Object name dbo.xxxxx"
body: <p>I have created a EmpDB and created a table "EmpTable" when I try to create a simple SP I am getting compile time error "Invalid Object name dbo.EmpTable" - why?</p>
  
  <p>Following is the sql statements</p>
  
  <pre class="lang-sql prettyprint-override"><code>use EmpDB;
  Go
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  -- =============================================
  -- Author:      &lt;Author,,Name&gt;
  -- Create date: &lt;Create Date,,&gt;
  -- Description: &lt;Description,,&gt;
  -- =============================================
  
  CREATE PROCEDURE usp_GetEmpNames
  
  AS
  
  SELECT * FROM dbo.EmpTable
  </code></pre>