CODEWITHSUNDEEP
sql-serverinsertssms
kabouterhuisje
kabouterhuisje

Reputation: 67

How to get rid of SQL Server Invalid Object name error?

I'm trying to insert some data into a table within SQL Server.

Below is the query that I use, but I get an error

'Invalid Object Name'

in SQL Server Management Studio.

The table does exist within the list of tables, and my database is set to 'BC-TEST' as well.

enter image description here

When I type the exact same query again, it works:

enter image description here

Done some research, and a lot of posts are referring to either caching or the database that is not set to the correct one. However none of these seems to be the case here.

Can someone help me out?

Cheers!

Upvotes: 0

Views: 939

Answers (1)

Alfin E. R.
Alfin E. R.

Reputation: 928

Both are two different queries, they are not the exact same.

The first query insert into [...$packaging processing], while the other one, the second query insert into [....$packing processing]

if the second query works perfectly, then the correct table must be [....$packing processing]

Upvotes: 1

Related Questions