208: Invalid object name
SQL ServerWhat does it mean?
The table, view or object referenced in the query was not found. SQL Server could not resolve the specified name.
Why does it happen?
A misspelled object name, wrong database/schema context (a schema other than dbo), the object really not existing or not created yet, or a missing two-part name (schema.table).
How to fix it
Spell the object name and schema correctly; use the qualified name (e.g. dbo.Customers). Make sure you are connected to the right database (USE). Check that the object exists: SELECT * FROM sys.objects WHERE name = 'YourObjectName'. Make sure temporary tables are created within the same session.
More from this engine
- 1222Lock request time out period exceeded
- 9002The transaction log for database is full due to ...
- 1105Could not allocate space for object in database because the filegroup is full
- 229The SELECT/EXECUTE permission was denied on the object
- 4060Cannot open database requested by the login. The login failed
- 233A connection was successfully established with the server, but then an error occurred (no process is on the other end of the pipe)
- 823The operating system returned error to SQL Server during a read/write at offset in file (I/O error)