DDL Trigger copied with backup restore.

Question

I've restored a database from production on my local machine, and I cant run any ddl statements on it because it triggers a ddl trigger that only exists on production, on a different database.

the error I get
Msg 208, Level 16, State 1, Procedure DDL_DATABASE_LOG, Line 30
Invalid object name 'PerfDB.dbo.DDLEventLog'.

How do I "disable" this trigger?

Answer 1

Hi,
Please use the below link where you can get the queries to disable to trigger and you can also do it for multiple triggers at one go.

http://msdn.microsoft.com/en-us/library/ms189748(SQL.90).aspx


Please Vote & "Mark As Answer" if this post is helpful to you.

Cheers
Bikash Dash
MCDBA/MCITP