CREATE TRIGGER [block_ddl]
    ON DATABASE
    FOR ALTER_PROCEDURE, DROP_PROCEDURE[, 
        ALTER_TABLE, DROP_TABLE, 
        ALTER_FUNCTION, DROP_FUNCTION, 
        ALTER_INDEX, DROP_INDEX, 
        ALTER_VIEW, DROP_VIEW,
        ALTER_TRIGGER, DROP_TRIGGER]
    AS
    BEGIN
        -- RAISE error so that we can prevent drop procedure
    END

GO
CREATE PROCEDURE testProc
WITH ENCRYPTION
AS
BEGIN
	select 'This is test proc for preventing users fron droping this procedure'
END
GO
CREATE TRIGGER Utr_deny_DROP_Procedure
ON DATABASE
FOR DROP_PROCEDURE
AS
BEGIN
	RAISERROR('Can not drop This Procedure',
    10, -- Severity.
    1 -- State.
	);
END
GO
DROP PROCEDURE testProc