SQL Server Performance

Invalid object name

Discussion in 'SQL Server 2008 General DBA Questions' started by darkangelBDF, Sep 13, 2009.

  1. darkangelBDF Member

    Hi there. I need some advice, pleaseeeee.
    I restored a backup of a database called RedworldArchive from our production server to one of our other servers. The restore completed fine. But now when I try to clean up orphaned users, etc. I get an error message. What is puzzling is that in the error message it refers to a completely different database (that is on the production server but not on the one the backup was restored to). Both servers have SQL versions of 2008 (SP1) - 10.0.2531.0 (Intel IA-64). The error message I get is:
    Msg208, Level 16, State1, Procedure trgDDLEvent, Line 12
    Invalid object name 'RedworldAdmin.dbo.DDLEvent'.
    Even when I try and change the dbowner it gives the same error message. How can I solve this?
  2. darkangelBDF Member

    Don't mind me. After hunting around a bit I discovered a trigger that logs all DDL events to a database called RedworldAdmin. I disabled the trigger on the server the DB was restored to and everything is working fine.

Share This Page