I am using SQL Server 2008 Management Studio. I've got a
.bak backup file from a client to resolve a specific issue.
Once I restore the database from the
.bak file, I am unable to do any alter query or alter master key.
In my new database, all the triggers that were created at the client environment DB is attached to it. So getting the below error.
Msg 208, Level 16, State 1, Procedure dbtrg_DBEventsmodel, Line 16
Invalid object name 'DBMonitor.dbo.ddl_DBEvents'.
Is there any way to detach those triggers in the restored DB ?