(Laurent Leturgez) This script is based on a SECURED_OBJECTS table and a CHECK_BEFOREDROP trigger that will prevent the deletion of objects. The trigger tests if the object you try to delete is in the table. If true, an error occurs and the object is not deleted. (script)
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help