Re: call sp_MSmakegeneration (?)

From: Fany Vargas [MSFT] (fanyv_at_online.microsoft.com)
Date: 12/16/04 

Date: Thu, 16 Dec 2004 15:21:51 GMT

I want to confirm that what you mean is that on the subscriber you do not
see a SRVID of 0 for the subscriber server when running sp_helpserver on
the subscriber. So for example if my subscriber server is called
SUBSCRIBER1\INST1, and sp_helpserver on this subscriber shows:

name id
------------ ----
SUBSCRIBER1\INST1 0
nameofpublisherserver 1

then there is no problem, however if you see something like:

name id
------------ ----
SUBSCRIBER1\INST1 2
nameofpublisherserver 1

then there is a problem because you should have server ID 0 for the local
server. If that is the case you run the following to correctly set the
local server name :

                -- Drop the server with incorrect name
                EXEC sp_dropserver @server='SUBSCRIBER1\INST1'
                
                -- Add the correct server as a local server
                EXEC sp_addserver @server='SUBSCRIBER1\INST1', @local='local'

Reference:
PRB: Replication setup is not successful when SQL Server 2000 is - ID:
818334
http://support.microsoft.com/?id=818334

Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Re: SQL2000 - Merge Replication - Timeout error
    ... The timeout is in your publisher and distributor server, ... Then, update the database statistics. ... Run profiler on the subscriber to see what is going on? ...
    (microsoft.public.sqlserver.replication)
  • Re: replication latency
    ... We need transactions committed as quickly as possible in Manila (Server ... This means applications would need to wait for the subscriber to ... Looking for a SQL Server replication book? ... Publication FULL: Transactional/Immediate updating subscriptions ...
    (microsoft.public.sqlserver.replication)
  • Re: Looking for Design Input
    ... Delivery transport options -- such as how what email addressto sent to, ... DeliveryOptions attached to each Subscriber (or perhaps for even one per ... server is different for different options. ... or if one server handles several mailing lists. ...
    (comp.lang.smalltalk.dolphin)
  • Re: SQLEXPRESS Replication?
    ... The way the Technet SQL BOL is arranged it is difficult to know just how to setup the required permissions to do replication which is the major stumbling block. ... You can replication from SQL Server 2005 Workgroup edition and above ... to a SQL Server Express subscriber using transactional replication. ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot or merge replcation propagation problem
    ... I use sa user account to connect to the subscriber. ... In SQL 2000 to make this change expand the replication folder, ... subscription, select properties, and in the subscriber connection, click ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)