--DML Triggers
use shopping1
create trigger trig2 on block_ex1 after insert,delete
as
print 'not allowed to change production database' rollback

raiserror ('not allowed to change production database',16,10)
drop trigger trig2

insert into block_ex1 values(1)

--ERROR: Msg 50000, Level 16, State 10, Procedure trig1, Line 2
--not allowed to change production database
--not allowed to change production database
--Msg 3609, Level 16, State 1, Line 1
--The transaction ended in the trigger. The batch has been aborted.

drop trigger trig1
--DDL triggers
create trigger trig8 on database for drop_table as --raiserror ('not allowed to change production database',16,10)
print 'You are dropping the production table'
rollback

drop table block_ex1
drop trigger trig8
drop trigger safety on database