It looks like adding an object to a transaction replication publication updates the modify_date in sys.objects. I believe that is what is pulling the dependency out from under the...

Based on my testing, the xp_regread method will return the physical machine name while xp_getnetname returns the cluster name, not the physical machine name. Something to consider when determining...