title: Invalid Object Name - Stored Procedure
body: <p>I am creating a stored procedure in SQL Server via SSMS. </p>
  
  <p>I have written the stored procedure below, however when I click <strong>execute</strong> it am given the error:</p>
  
  <p><em>Msg 208, Level 16, State 6, Procedure NewQuestion, Line 11
  Invalid object name 'hgomez.NewQuestion'.</em></p>
  
  <p>the table is ownership is correct. (hgomez.Questions)</p>
  
  <pre><code>USE [devworks_oscar]
  GO
  /****** Object:  StoredProcedure [hgomez].[NewQuestion]    Script Date: 10/23/2011 23:55:08 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  ALTER PROCEDURE [hgomez].[NewQuestion]
      (
      @QUESTIONNAME nvarchar(50),
      @QUESTION_ID int OUTPUT
      )
  
  AS
      /* SET NOCOUNT ON */
      INSERT INTO [Questions] (QuestionText) VALUES (@QUESTIONNAME)
      SET @QUESTION_ID = SCOPE_IDENTITY();
      RETURN
  </code></pre>
  
  <p>Thanks in advance</p>