Invalid object name

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?

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.