Q:

Use dbo.table SQL Server error

I have a database, and I am importing a big table...
When I try to execute a stored procedure I have no success, to check I do something simple like:
select * from tableAT;

but the tableAT is marked as error (even when it appears in the Object explorer window), 
Msg 208, Level 16, State 1, Line 1
Invalid object name 'tableAT'.

but if I do right click and select the icon of the table and select
SELECT TOP 1000 ROWS
a result is coming and the query shown is 
SELECT TOP 1000 [1]
      ,[2], etc...
  FROM [DB_NAME].[dbo].[tableAT]

if I change the way I am calling the store procedure to 
exec procedureA [DB_NAME].[dbo].[tableAT]

I get error as if the table does not exist?
Do you know why could this be error?
A size issue, I already incremented the database initial size files...

A:

You must be logged in as admin user to select from this table. Because it is created for dbo. Or you should have proper rights

