Invalid Object Name 'owner.table' on DELETE

Posted on 2006-05-19
Last Modified: 2011-04-14
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.

Question by:ljaques
    LVL 8

    Expert Comment

    instead of restoring the database,

     delete your current database
     get the original .MDF and .LDF files
     put them in your data directory
     use the Attach Database Option by right clicking databases and choosing all tasks
     when the dialog comes up browse to the .MDF File and select it
     then change the Specified Database Owner to sa

    once it is attached, it should work just fine.
    LVL 12

    Accepted Solution

    did you also check triggers on table?

    Author Comment

    yes i checked triggers but nothing listed.

    Author Comment

    I do like the mdf/ldf copy approach however when i attempt to copy the 2 files i get a "cannot copy xxx. sharing violation" error message.  I dont want to stop the sql server on the production server just to make a copy.  Is there a way around this sharing violation on copying?

    Author Comment

    Whoops there were some triggers with the rian name in it.  Adjusted and all is fine now. thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now