?
Solved

Invalid Object name in Sql Server Database

Posted on 2014-03-17
3
Medium Priority
?
1,263 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 2000 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

This article surveys and compares options for encoding and decoding base64 data.  It includes source code in C++ as well as examples of how to use standard Windows API functions for these tasks. We'll look at the algorithms — how encoding and decodi…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
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…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

765 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