CODEWITHSUNDEEP
sqlsql-server-2008
edgarmtze
edgarmtze

Reputation: 25038

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...

Upvotes: 0

Views: 1679

Answers (2)

Anil Soman
Anil Soman

Reputation: 2467

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

Upvotes: 1

Nathan DeWitt
Nathan DeWitt

Reputation: 6601

Make sure you've set up your table valued parameter correctly: here's an example.

Upvotes: 0

Related Questions