Where does a Server trigger save in SQL Server?
Posted
by
Mostafa
on Stack Overflow
See other posts from Stack Overflow
or by Mostafa
Published on 2010-10-01T21:49:26Z
Indexed on
2012/10/30
11:02 UTC
Read the original article
Hit count: 261
A couple of days ago , I was practicing and I wrote some triggers like these :
create trigger trg_preventionDrop
on all server
for drop_database
as
print 'Can not Drop Database'
rollback tran
go
create trigger trg_preventDeleteTable
on database
for drop_table
as
print 'you can not delete any table'
rollback tran
But the problem is I don't know where it has saved and How can I delete or edit those.
Thank you
© Stack Overflow or respective owner