Post reply

Modify table structure

  • July 29, 2003 at 2:31 pm

    #358095

    I can't modify table structure for example: to add new fields and delete old fields, etc after I set up a replication publisher on a database. I have to drop the publication to do any ta ble changes. Is there any easy way to change tables without drop the replication publishers.

  • July 29, 2003 at 3:47 pm

    #467622

    Yes, you can use sp_repladdcolumn and sp_repldropcolumn.

  • July 30, 2003 at 6:06 am

    #467700

    sp_repladdcolumn and sp_repldropcolumn only work on SQL 2000, plus all subscribers must be SQL 200 as well.

    [font="Verdana"]Markus Bohse[/font]

  • August 4, 2003 at 4:26 am

    #468405

    Hi MarkusB,

    May I know, how to drop a table in publication?

    Thanks in advance?

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

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