title: Stored procedure parses correctly but will not execute. Invalid object name. Msg 208
body: <p>I've scripted up a stored procedure as follows.  It will parse without errors, but when I try to execute it, it will fail.  The error message reads: Msg 208, Level 16, State 6, Procedure aspnet_updateUser, Line 23
  Invalid object name 'dbo.aspnet_updateUser'.</p>
  
  <p>Here is the stored procedure.</p>
  
  <pre><code>    USE [PMRS2]
  GO
  /****** Object:  StoredProcedure [dbo].[aspnet_updateUser]    Script Date: 05/25/2009 15:29:47 ******/
  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;
  -- =============================================
  ALTER PROCEDURE [dbo].[aspnet_updateUser]
      -- Add the parameters for the stored procedure here
      @UserName nvarchar(50),
      @Email nvarchar(50),
      @FName nvarchar(50),
      @LName nvarchar(50),
      @ActiveFlag bit,
      @GroupId int
  
  AS
  BEGIN
      -- SET NOCOUNT ON added to prevent extra result sets from
      -- interfering with SELECT statements.
      SET NOCOUNT ON;
  
      -- Insert statements for procedure here
  
  UPDATE dbo.aspnet_Users 
      SET UserName = @UserName, LoweredUserName = LOWER(@UserName), Email = @Email, FName = @FName, LName = @LName, ActiveFlag = @ActiveFlag, GroupId = @GroupId
      WHERE LoweredUserName = LOWER(@UserName)
  END
  </code></pre>