Microsoft sql server ошибка 208

This is the error message returned:

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

It happens after I try the following query:

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',
'',
'',
'',
'',
'',
'',
'' )

In this article we explain about ERROR 208, why it occurs and how to deal with it.

We often come across situations which seem to be very complicated and challenging but are actually very easy to get out of; provided we think logically. One such situation a lot of SQL Server DBA’s come across is the SSMS error 208, i.e. the ‘Invalid Object Name’ error. This is a very commonly occurring error which ends up confusing a lot of DBAs. So today, we will not only provide you with a solution to this problem, but also suggest you ways to avoid it from occurring in future.

What is Error 208 in SSMS

A lot of us or those DBAs who are not very experienced with using SQL Server, usually opt for exploring the software with the help of SQL Server Management Studio (SSMS). And while you are at it, you might click at a given object to know more about it, and suddenly come across a pop up stating ERROR 208! This is a point where a lot of you might get stuck. But after reading this article we hope things would get better as you would get a greater understanding of the subject.

What is most perplexing about this error to majority of DBAs is the fact that the object is visible to them in SSMS Object Explorer window but when they attempt to select it using T- SQL, they witness the error. This is the point where a lot of DBAs switch to extreme and desperate measures like restarting SSMS multiple times to furiously refreshing queries, restarting databases, etc. But to their sorrow, none of this will provide them with the solution they are looking for.

These practices fail to work because none of these is addressing the root cause of the error which is nothing but simple mismatch in database context.

How to Solve Error 208 in SSMS

Now that you know what is causing the error, finding the solution should not take long. The most common reason for this context mismatching error to occur is the fact that the default database context has been set to master. Well in 99 out of 100 cases, this ends up being the cause. And if this really is what is causing the error to appear in your system, then a very basic thing for you to do is changing the context of the database. And while you are at it, change it in a way that the context becomes similar to the current database object that is in use.

Once you perform this step, you will be glad to see that the error will appear no longer, and all other functions will also happen smoothly. This is one of those errors that almost every single DBA would have experienced, but few would actually know a way out of this situation without considering a repair sql action. This article would hopefully be of help to all of them. Apart from the solution given above, there is one more option that DBAs can try out; this involves prefixing multipart database name to the database that is in use. Or you might also want to change the database that opens by default once you login SSMS.

Author Introduction:

Victor Simon is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including corrupted mdb and sql recovery software products. For more information visit https://www.datanumen.com/

I am moving data and SSIS packages from SQL Server 2014 database server to SQL Server 2016 server.

I began with building the new server and installing SQL Server 2016 Standard edition. Then I backed up the data on the 2014 server and restored it onto the new server 2016 server. Including SSISDB.

One of the items that needs to be done is to go into the SQL Server Agent jobs and modify any step that is of the type SQL Server Integration package and change the server parameter in the package to the name of the new server.

However when I try to do that I get the following error message:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
ADDITIONAL INFORMATION: Invalid object name ‘SSISDB.catalog.customized_logging_levels’. (Microsoft SQL Server, Error: 208)

I get the same message when I try to look at the SSISDB Integration Catalog

One article I found recommended the following steps:

• Backup SSISDB database from SSMS 2014.
• Create Integration Service catalog on SSMS 2017 and restore backup.
• Change the SSISDB database owner sa.
• Right click on SSISDB under Integration Service Catalogs.
• Select Database Upgrade-> Select Next -> Select I have taken backup of the SSISDB database. continue with the SSISDB upgrade and Select Upgrade.

The last step (SSISDB upgrade) fails with the following message:

The SQL Server edition or version do not meet the minimum requirements to create a Master Data Services database. (Microsoft.SqlServer.IntegrationServices.ISServerDBUpgrade)

I would really appreciate any advice.

Thanks in advance

When trying to change the user account to link with the NewMary login:

EXEC sp_change_users_login 'Update_One', 'Mary', 'NewMary'
go

I get the error 208:

Msg 208, Level 16, State 1, Procedure ChangeLogging_LogDDLCommands, Line 147
Invalid object name ‘Utils.dbo.ChangeLogging_DDLCommands’.

I don’t find any relevant information on ChangeLogging_DDLCommands, and I’m lost at how I do have to proceed from there.