Initial error when querying SQL Server 2012 database

Question

Using SQL Server 2012, I created a database and a table:

When I query the table the first time (after I connect to SQL Server) using this query:

select * 
from [dbo].[Downloads]

I get

Msg 2809, Level 16, State 1, Line 1
The request for procedure 'Downloads' failed because 'Downloads' is a table object.

But the second time I execute the same SELECT statement, it runs correctly

How do I eliminate this error the first time around?

Answer 1

You had the text Downloads selected in Management Studio. This causes the T-SQL string Downloads to be executed. Such a T-SQL batch is interpreted as a procedure call.