Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: pullsubscription to SQL7 with MSDE8

    Hi there.

    I want to add a pull mergesubscription to a MSSQL7-Publisher using MSDE on the clientside. I used osql to run the following script on the clientside, but I get the error 'subscriber_server missing in table'
    Code:
    use [DB_to_sync]
    Go
    
    -- Adding the registered subscriber
    sp_addmergepullsubscription @publication = N'Publication_to_sync',
         	@publisher = N'MSSQL-Server',
    	@publisher_db = N'DB_to_sync',
    	@subscriber_type = N'local',
    	@subscription_priority = 0.0,
    	@sync_type = N'automatic'
    GO
    
    sp_addmergepullsubscription_agent @publisher = 'Publication_to_sync',
    	@publisher_db = 'DB_to_sync',
    	@publication = 'Publication_to_sync',
    	@publisher_security_mode = 1,
    	@publisher_login = 'sa',
    	@subscriber = 'Subscriber',
    	@subscriber_db = 'Subscriber_DB',
    	@subscriber_security_mode = 0,
    	@subscriber_login = 'sa',
    	@distributor_security_mode = 0,
    	@distributor_login = 'sa',
    	@enabled_for_syncmgr = 'true'
    Go
    Last edited by cameltoe; 10-13-03 at 14:50.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •