EXEC sp_helpdistributor;

EXEC sp_helpdistributiondb;

EXEC sp_helpdistpublisher;

I think the original post would have worked but you needed to update the stored distributor server info that replication is using.

If you look at the SP "sp_get_distributor" I believe...

Also great article.. I have never found a good explanation of these column meanings so this wasa very useful article!

You are correct that fixed that.. Not sure How I missed that apologies..

Getting errors executing the script as well.. Maybe is related to the fact that I have multiple schemas in the database?

i.e. Report.work_order,

dbo.items, work.operations

(0 row(s) affected)

(536 row(s) affected)

Warning:...