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

Related posts about sql-server

Related posts about sql-server-2005