May 18, 2007 at 1:35 pm
Hi All,
I'm executing sp_helpdistributor in SQL2005 but no results are being returned. In SQL2000 the following query works OK and returns a resultset:-
exec master..sp_helpdistributor
Can anybody shed any light, do I need to enable a component or execute the query differently?
Any advice or help would be extremeley welcome and most appeciated.
Many thanks in advance.
May 18, 2007 at 2:27 pm
that works on my replication if i run it on the distributor
May 19, 2007 at 2:15 am
tried it but still no results being returned.
May 19, 2007 at 5:26 am
Some further information:-
As no results are being returned from sp_helpdistrbutor I go on to setup
a distributor on the server using the code below:-
master..adddistributor @distributor = <server>
When I do so an error comes back reading "The
server MyServer is already defined as a Distributor".
This just confirms my original theory in thinking that the sp_helpdistributor needs to be called differently or a permission issue or a component needs installing.
October 4, 2010 at 3:31 pm
Stepping through the code using SQL 2008 shows that sp_helpdistributor has a "feature" where it will return nothing if it doesn't find an entry in MSdistpublishers, even if it does detect that the server is designated a distributor. This "feature" even has a comment stating:
-- If distribution db is NULL, there is no matching distributor.
-- This typically would happen when calling on a distributor that
-- only has HREPL publishers. This case should result in no output
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply