SQL Server: invalid object name how to solve it?

Question

error returns to me in below codes:

Msg 208, Level 16, State 1, Line 1 Invalid object name 'ENG_PREP'.

insert into ENG_PREP VALUES('572012-01-1,572012-01-2,572012-01-3,572013-01-1,572013-01-2',
'',
'500',
'',
'A320 P.001-A',
'Removal of the LH Wing Safety Rope',
'',
'',
'',
'0',
'',
'AF',
'12-00-00-081-001',
'',
'',
'',
'',
'',
'',
'' )

Answer 1

It means that it doesn't know what ENG_PREP is.

You need to use a 'use xxx' (where xxx is the database name where the ENG_PREP lives) command first to tell it what database you are using. And once you do that, you need to make sure that ENG_PREP is present in that database.

If you're using .Net to connect, you need to make sure you specify the initial catalog so it knows what database to use, here's an example excerpt from a web.config:

<add name="SqlConnection" connectionString="Data Source=(local)\SQLEXPRESS;Initial Catalog=your_db_name_here;Integrated Security=True"
     providerName="System.Data.SqlClient" />

Answer 2

I means the table ENG_PREP doesn't exist in the connection you are using.

Check if you are connected to the right server/database. Also check the table name.

Answer 3

Sounds like it can't find the table.

Check that you're connected to the correct database.
That the table exists and that it's the correct spelling.