Invalid Object Name 'owner.table' on DELETE
Posted on 2006-05-19
Im using MS Sql Server 2000 under Windows XP. We have Rainbow Portal v1.6 installed at work as well as at home. What I've done is made a backup of the database from work and restored the database on my home server. The restoration was successful however every table, stored procedure, view, etc ha its owner set to "chase" my name at work. The Rainbow portal refused to work until i switched the owner to "dbo". I did this with the following stored procedure on every table, stored proc, view, etc:
EXECUTE sp_changeobjectowner 'chase.FunctionName','dbo'
Rainbow Portal worked fine after that. The problem Im now having is I try to remove an invalid entry in one of the tables and i consistently receive the error message:
[Micrsoft][ODBC SQL Server Driver][SQL Server] Invalid object name 'chase.rb_EnchancedHtml_st'
I've tried disabling relationships amongst some tables but the error message just changes to yet another table name. It never ends.
Is there a way to resolve this whole "chase" owner issue from the backup/restore phase so that the owner is "dbo" completely with no mention of "chase" anywhere in the database file? Even if theres a fix i can apply to my current database I'd take it.