Re: Please Help....

From: S.Azish@Systemadvance.co.uk
Date: 10/10/02 

From: <S.Azish@Systemadvance.co.uk>
Date: Thu, 10 Oct 2002 18:13:56 +0100

Thnaks Linda, everything seems to be ok. I solved problem in another way
though. It was happening when that server was subscriber in another server.
Thanks very much anyway.

  Saeid

"linda deng[MS]" <lideng@online.microsoft.com> wrote in message
news:1qnh7vAcCHA.2164@cpmsftngxa08...
> Hi Saeid,
>
> Please check the column 'priority' of the system table
> 'sysmergesubscriptions'. When the server is used as an anonymous
> subscriber, the value of this column will be equal to 0. So the error will
> appear when running sp_addmergepublication.
>
> You can drop this anonymous subscription to reset this column, or update
> the system table 'sysmergesubscriptions' manually to set priority as
100.0,
> then please run the stored procedure to create a replication again.
>
> If anything is unclear, please let me know.
>
> Sincerely,
>
> Linda Deng
> 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)