Post reply

Abt Transaction Replication in Sql 2000 - ASAP Plz

  • May 15, 2008 at 7:04 am

    #103492

    Hi Flocks,

    I'm very new to replication process and could not make it up.

    I have followed the followinf like to done up with replication process.

    http://support.microsoft.com/kb/820675

    It has been impemented as it is and every thing was up and running.

    But i neeed to test a senairo wher the test2 database has been add an additional column

    and i have changed the referencing stored procedure too.

    Now when i insert a row from test1 data base i have encountered the following error

    at Publisher of test1 database

    ERROR - Procedure 'sp_ins_two_way_test2' expects parameter '@testcol', which was not supplied.

    In the same way when i tried to push data for test2 data base following error occured at

    Publisher of test2 database

    Error - Procedure or function sp_ins_two_way_test1 has too many arguments specified.

    Can anybody slove this problem and come out with a solution.

    Thanks in Advance!

    ---Kalyani

  • May 16, 2008 at 8:12 am

    #816517

    Hmmm,

    If the table is not too big, I would remove it from the publication, make the structural change and then add it back.

    The process might be

    Drop subscriptions to the article

    Drop the article

    Make the change

    Add the article

    Add the subscriptions

    Run the snapshot agent (without reinitializing the whole publication)

    Run the distribution agent.

    You might need to fix the replication SPs so they are consistant with the table structure.

    Regards

    Graeme

  • May 20, 2008 at 12:47 am

    #817597

    Hi Graeme ....

    Thnx for your valuable answer.

    I have followed the same but even then i could not achive the results.

    Still i'm facing errors.

    First of all please let me clear one thing..........

    Will the replication is possible when schemas of the two servers are different.

    If so plz guide me in this regards.

    Warm Regards,

    Kalyani

  • May 20, 2008 at 1:31 am

    #817618

    Hi,

    Surely when you apply the snapshot this will synchronise the schemas on Publisher and Subscriber.

    Is the table you have modified now consistent on pub and sub ?

    Regards

    Graeme

  • May 20, 2008 at 1:41 am

    #817624

    nope....still not consistent on both.

    Thanks,

    Kalyani

Viewing 5 posts - 1 through 4 (of 4 total)

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