Procedure names must comply with the rules for identifiers. Renaming a stored procedure retains the object_id and all the permissions that are specifically assigned to the procedure. Dropping and ...

Simple solution for regular checking of replication subscriptions based on querying system tables on distribution server. Require Database Mail to notify you everytime some subscription is not running ...