Prev: Replication Solution
Next: Increasing Max Text Repl Size
From: Paul Ibison on 21 Oct 2009 16:23
It's missing @enabled_for_syncmgr=true in sp_addmergesubscription -
hopefully this is it.
paul


"Karsten" <Karsten(a)discussions.microsoft.com> wrote in message
news:0662C07B-35E2-4E33-ADF5-0313B5B1B4D8(a)microsoft.com...
> Hi Paul!
>
> Here´s the script of the subscription...
>
> -------------------------------------------------------------------------------------------
> -- Mergepullabonnement wird hinzugefügt
>
> /****** Anfang: Auf dem Abonnenten auszuführendes Skript ******/
> use [TheApplication_Replikat]
> exec sp_addmergepullsubscription
> @publisher = N'PublisherDistributorServer',
> @publication = N'TheApplication',
> @publisher_db = N'TheApplication',
> @subscriber_type = N'Local',
> @subscription_priority = 0,
> @description = N'',
> @sync_type = N'Automatic'
> GO
>
>
> exec sp_addmergepullsubscription_agent
> @publisher = N'PublisherDistributorServer',
> @publisher_db = N'TheApplication',
> @publication = N'TheApplication',
> @distributor = N'PublisherDistributorServer',
> @distributor_security_mode = 1,
> @distributor_login = N'',
> @distributor_password = N'',
> @enabled_for_syncmgr = N'True',
> @alt_snapshot_folder = N'',
> @working_directory = N'',
> @use_ftp = N'False',
> @job_login = null,
> @job_password = null,
> @publisher_security_mode = 1,
> @publisher_login = N'',
> @publisher_password = N'',
> @use_interactive_resolver = N'False',
> @dynamic_snapshot_location = N'',
> @use_web_sync = 0
> GO
> /****** Ende: Auf dem Abonnenten auszuführendes Skript ******/
>
>
> /****** Anfang: Auf dem Verleger auszuführendes Skript ******/
> /*use [TheApplication]
> exec sp_addmergesubscription
> @publication = N'TheApplication',
> @subscriber = N'NOTEBOOK\TheApplicationLOKAL',
> @subscriber_db = N'TheApplication_Replikat',
> @subscription_type = N'pull',
> @subscriber_type = N'local',
> @subscription_priority = 0,
> @sync_type = N'Automatic'
> */
> /****** Ende: Auf dem Verleger auszuführendes Skript ******/
>
> -----------------------------------------------------------------------------------------
>
> Thanx in advance
>
> Greetings
>
> Karsten
>
>
>
>
> "Paul Ibison" wrote:
>
>> Please can you post up the script of the subscription and I'll takea
>> look.
>> Cheers,
>> Paul Ibison
>>

First  |  Prev  | 
Pages: 1 2
Prev: Replication Solution
Next: Increasing Max Text Repl Size