Post reply

Alter schema of the table which is part of replication

  • May 24, 2011 at 3:50 am

    #240164

    I am getting below error when I try to alter the schema of one of the table. Table is replicated to other server.

    Msg 21814, Level 16, State 1, Procedure sp_MStran_autoproc, Line 178

    DDL replication failed to refresh custom procedures, please run "exec sp_register_custom_scripting 'CUSTOM_SCRIPT', your_script, 'Database', 'Tablename' "and try again

    Msg 3609, Level 16, State 2, Line 29

    The transaction ended in the trigger. The batch has been aborted.

    Please let me know if any solution is there to overcome this isssue.

  • July 17, 2012 at 2:50 am

    #1513455

    hey Raj

    getting same error.Got any solution

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

  • July 17, 2012 at 8:00 am

    #1513616

    Before changing the schema of the table, change the Custom replication SP to include the column to be added in the input parameters. Execute the SP first and then alter the table.After table alter, you can update the Custom replication SP logic, if needed.

    Above steps worked for me.

    Thanks.

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

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