Skip to main content Skip to footer

Error Invalid object name 'TABLE' after a database upgrade

You may get an error like Invalid object name '<database table> after upgrading your database. If this is the case, it is most likely that you upgraded while logged in with a different user account than the usual Promodag account. In this case, the updated or newly created tables and stored procedures are not associated with the dbo schema and Promodag Reports cannot see them.

How to verify it

Start SQL Server Management Studio, click on your database to display the contents of the various folders, then expand the Tables subfolder to display the list of tables. Make sure they are all prefixed with "dbo".
Repeat this operation with the Programmability > Stored Procedures subfolder. All stored procedures located at the root must also be prefixed with "dbo".

How to change the schema of a table to dbo

In SQL Server Management Studio, right click on the table, select Design, then press F4 to display its properties. Change the schema to dbo.

How to change the schema of a store procedure to dbo

In this case you will have to execute a query:
ALTER SCHEMA dbo TRANSFER <stored procedure name>

Example: ALTER SCHEMA dbo TRANSFER TLF_getExternalEmailTr

Try Promodag Reports Free for 45 Days

Cookie Notice

Find out more about how this website uses cookies to enhance your browsing experience.