DDL TRIGGERS - stopping procedure table to be modified or created

 create Trigger Tr_CleanSlateProtocol

On database // this doesnt mean whole database in your sql server just the opened one

For ALTER_TABLE,DROP_TABLE,ALTER_PROCEDURE,DROP_PROCEDURE --,Alter_StoredProcedure,Drop_StoredProcedure

as Begin

Rollback

print('perticular action in this database is prohibitated')

end

disable Trigger Tr_CleanSlateProtocol on database //on database should not be ommited.

enable Trigger Tr_CleanSlateProtocol on database