I had to create an alias to the distributor on the publisher to solve the issue. Thanks

Hi Michael,

I found your script very useful. Now i am stuck in a situation where i have to shrink the datafile to reclaim disk space. the datafile that i...