Post reply

How to modify a table if it is in use for replication

  • August 27, 2004 at 6:36 am

    #86503

    Hi need modify a field on the table but it is using for replication and sql don't let me do it, unless

    i drop the replication, any way to work around that?

    thanks

  • August 27, 2004 at 8:07 am

    #520875

    If you want to change an existing column you have to remove replication. If you want to add a column or drop a column SQL2000 has two store procedure sp_repladdcolumn and sp_repldropcolumn which allow you to so without removing the replication.

    M

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

  • August 27, 2004 at 8:12 am

    #520878

    There are ways to do it, some easier than others depending on the version of SQL you have. If you look at the list of articles I've publishered there are two on the subject, for for SQL 7 and for SQL2K - title starts with "altering replicated". Look that over, if you've got questions after that I'll be glad to help.

    Andy
    Connect with me on LinkedIn

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

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