Post reply

Add column to subscriber table

  • July 25, 2010 at 12:33 am

    #1197914

    Thanks will do just that.

    When done, I will return to this thread and post my findings... Then you can be my sense checker 🙂

  • February 2, 2011 at 3:54 am

    #1281323

    I have a question in the same context.

    I have a transactional replication setup. Now I want to add a column only to a table on the subscriber side. (A trigger on this table will fill the new column when a row is added by the replication)

    When is simply do this, the replication fails with the following message:

    Insert Error: Column name or number of supplied values does not match table definition

    Is there a way to accomplish this without having to alter the MS-stored procedures?

  • February 3, 2011 at 5:13 am

    #1281825

    I am not sure how you created the sprocs - I used the defaults and the MS generated insert sproc specifies the columns.

Viewing 3 posts - 16 through 17 (of 17 total)

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