sql server replication: Hi All

I have an application that correctly sets up a publication on a SQL2K
database and we are now in the process of testing the same mechanism
against a 2005 database but we have hit some issues.

I'm executing sp_helpdistributor in SQL2005 but no results are being
returned using the query below:-

exec master..sp_helpdistributor


As no results are being returned from the above query I go on to setup
a distributor on the server using the code below:-

master..adddistributor @distributor = <server>

An error comes back when I execute the above, the error reads "The
server MyServer is already defined as a Distributor".

To me this indicates that the first query sp_helpdistributor is not
working properly.

Do I need to call the SP differently in SQL2005 or am I missing a
component or needing to enable something?

Any advice or help would be extremeley welcome and most appeciated.

Many thanks in advance.

Just looked at the text of sp_helpdistributor and I believe it could be that
the proc returns zero rows if the servername is incorrect. Please can you run
select @@servername and check it is the current netbios name.

Hello, everybody!

I have same problem... As it seems, replication mechanism in SQL2005 differs
from SQL2000.

As I noticed:
1. In SQL2000 sp_helpdistributor always returns correct information about
the distributor, if it is configured;
2. In SQL2005, if there are configured both distributor and publisher, this
stored procedure returnc correct information;
3. In SQL2005, if distributor is configured and it has no publishers, the
procedure returns zero rows;
4. If distributor is not configured, the procedure returns a row consisting
of NULL values, both in SQL2000 and SQL2005

In my case server name fo both servers is correct:
SERVERPROPERTY('MachineName') and @@SERVERNAME return the same name.

I think, that it might be a bug in SQL2005. The stored procedure text is
changed in SQL2005, the changes are valuable, and I cannot determine where is