Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rock_query
Yak Posting Veteran
55 Posts |
 Posted - 2013-04-05 : 17:25:48
|
| Msg 208, Level 16, State 1, Line 4Invalid object name 'HumanResources.EmployeeTable1'.In the AdventureWorks2012 database I created a table called EmployeeTable1 under the HumanResources schema. Yesterday I was able to retrieve data from this table. Now it's not working. I refreshed the database, the tables folder and still nothing. I tried Edit, IntelliSense, Refresh local cache and still nothing.I am using SQLExpress2012 on my PC.What am I doing wrong? |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-04-05 : 17:38:34
|
| Are you connected to the server under the same security context that you were previously? Can you connect as SA or as a server administrator to see if it is a permission issue?Are you sure you created it on your local instance and your weren't connected to some other sql server instance?Be One with the OptimizerTG |
 |
|
|
|
|
|
Msg 208,Invalid object name 'HumanResources.Employ