Applied Concepts HR/Payroll

Home Search Tags Glossary

Welcome Guest ( Login | Register )

Home » articles » HR/Payroll (emPath) » Technical » SQL » Resolve an invalid object error by changing ownership of a...

Resolve an invalid object error by changing ownership of a SQLserver object (table, function, ect).

Resolve an invalid object error by changing ownership of a SQLserver object (table, function, ect).

Issue: While helping a client upgrade to emPath 6.4 the log for the DatabaseDeploymentUtility included an error which was related to ownership of SQLserver objects. Note that this was not a bug in the emPath DatabaseDeploymentUtility. In fact the utility was identifying a problem which had occurred previously and gone undetected until the empath 6.4 upgrade. (See notes at the bottom of this article for examples of error messages received)

Resolution:
(1) using Query Analyzer identify the SQLserver objects which have an owner other than "dbo". The tables and functions should have ownership of dbo:

(2) If an object (table or function) has an ownership other than dbo you should change the ownership to dbo prior to running the emPath DatabaseDeploymentUtility. Following the SQL statement to change ownership in the above example:

sp_changeobjectowner 'xxx.AA2', 'dbo'

Note that errors in the log file of the DatabaseDeploymentUtility may look similar to the following: