Post reply

adding column to a replicated table

  • September 18, 2007 at 11:12 am

    #95398

    Hi,

    I am using the following to add a column to transaction replication.

    sp_repladdcolumn @source_object = '

    ',

    @column = '',

    @typetext = ' ,

    @publication_to_add = '',

    @force_reinit_subscription = 1

    I understand it will create a snapshot of the article the next time the snapshot agent runs.

    Will it delete all the existing data at the subscriber or just add the column because in the table article property 'delete all data in the existing table (at subscriber)is selected.

    Some help is greatly appreciated

  • September 18, 2007 at 1:37 pm

    #734395

    This will just add the column. Be sure to note that adding a column this way requires that the column be NULL'able or has a default.

  • September 18, 2007 at 2:47 pm

    #734411

    thank you.

    yes the column is NULL

  • September 18, 2007 at 4:19 pm

    #734430

    not sure what happened here but this thread looks "funky"


    * Noel

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

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