Hi Andreas, Thanks for the post, I ran the proc mentioned and it returns the name of the distribution server on the publisher, on the distribution server every thing is marked enabled(1) and again it contains the correct name for the distribution server.