Sql Server management studio "Invalid Object name dbo.xxxxx"

Question

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?

Following is the sql statements

use EmpDB;
Go
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:      <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================

CREATE PROCEDURE usp_GetEmpNames

AS

SELECT * FROM dbo.EmpTable

Are you sure that the schema for your table is `dbo`?, what happens if you do `SELECT * FROM EmpTable`? — Lamak, May 04 '12 at 18:54
See this question and answers: http://stackoverflow.com/q/1362531/292060 — goodeye, Feb 10 '15 at 03:02

score 1 · Answer 1 · answered May 04 '12 at 18:59

1

I just created a test version and ran your script with any issues.

A few things to check:

If you run just the SELECT does it run?

SELECT * FROM dbo.EmpTable

If not, then verify the schema the EmpTable is in and replace the dbo.

SELECT * FROM yourSchemaNameGoesHere.EmpTable

Make sure that your table that you created is in the correct database EmpDB and you didn't accidentally create your table in the wrong database.

answered May 04 '12 at 18:59

Taryn

242,637
56
362
405

yes, SELECT * FROM EmpTable works for me.I checked the table its right under EmpDB. – Srikanth May 05 '12 at 04:29
Yeah ......:) now its working there might be some DB refresh issue.After disconnect and connect its working. – Srikanth May 05 '12 at 05:35

score 1 · Answer 2 · answered Oct 16 '19 at 12:24

1

Make sure you have selected the right database on which you run the query. That was my issue.

answered Oct 16 '19 at 12:24

Noob

710
11
15

Sql Server management studio "Invalid Object name dbo.xxxxx"

2 Answers2