SSMS 18.2 gives error when performing DDL

Question

We upgraded to SQL Server 2016 SP1 and SSMS 18.2 last week. Today I've been trying to execute DML in the database and am getting this error message:

Msg 208, Level 16, State 1, Procedure backup_objects, Line 17 [Batch Start Line 9] Invalid object name 'msdb.dbo.changelog'.

I cannot find either backup_objects or msdb.dbo.changelog in any database of the instance, so I do not know how or why the calls backup_object are being made.

Any idea what may be causing this and how to get around it?

Answer 1

I figured it out. A previous DBA implemented a database trigger to log DDL changes. The trigger writes to the msdb.dbo.changelog table. When we converted the database from 2008 to 2016, that table didn't get moved over to the new instance because it was in msdb and not a user database. SSDT disabled the trigger before it ran DDL, so it worked just fine.