Solved

Invalid Object name in Sql Server Database

Posted on 2014-03-17
3
1,179 Views
Last Modified: 2014-03-17
As a dbOwner I am receiving the Invalid Object name  message on a table I just created and I see in the database.

How could that be?
0
Comment
Question by:metro156
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 39934254
>Invalid Object name
can happen if you created with a specific owner (normally, it's dbo), and then try to query the table without specifying that same owner, unless it is dbo or the same user as the current connection
or simply you are connected to another database in the sql sheet...
0
 
LVL 13

Accepted Solution

by:
jonnidip earned 500 total points
ID: 39934271
...or (assuming you are using SSMS), you need to refresh your Intellisense cache (CTRL+SHIFT+R)...
0
 

Author Closing Comment

by:metro156
ID: 39934343
That's what it was.
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Visual Studio Debugging 3 153
SAPE.heur.AE935 Visual Studio 3 63
How to copy an image file into clipboard C/C++? 1 218
Using MS Code on my Mac 6 72
What my article will show is if you ever had to do processing to a listbox without being able to just select all the items in it. My software Visual Studio 2008 crystal report v11 My issue was I wanted to add crystal report to a form and show…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question