Post reply

how can we create remote disributor?

  • September 20, 2012 at 7:51 am

    #261827

    I have to create a remote distributor can you please helpme out friends?

    Thanks in Advance 🙂

  • September 20, 2012 at 9:25 am

    #1540169

    Assuming we are talking replication. Do this.

    /* ************ */

    /*RUN ON DISTRIBUTOR*/

    USE master

    GO

    EXEC sp_adddistributor @distributor = 'distributorname' , @password='pa$$word';

    GO

    EXEC sp_adddistributiondb @database = N'distribution', @security_mode = 1;

    GO

    /* Make sure the UNC is prepared */

    USE distribution

    EXEC sp_adddistpublisher @publisher=N'publishername', @distribution_db=N'distribution', @security_mode = 1, @working_directory='\\distributorname\repl'

    GO

    and this

    /*RUN ON PUBLISHER*/

    USE master

    EXEC sp_adddistributor @distributor = 'distributorname', @password='pa$$word';

    GO

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply