When running a compare between SERVER011 and SERVER003, an error is given under Properties, in the compare tab:
"Cannot insert the value NULL into column 'owner', table 'tempdb.dbo.@spdbdesc...'; column does not allow nulls, INSERT fails. The statement has been terminated."
The error seems to occur only when SERVER003 is used in the compare. Other servers don't have any issues. The account used has the SYS Admin Role.
Some of the databases in the server have null/unknown as the 'owner', on the problematic server.
Review the databases of the server for any null/unknown values for the column 'owner'. When found, specify an owner for each missing.
Query to run to check each database:
EXEC sp_helpdb N'<database name>';
