• disabling the triggers did not work. if helps to see, here is the command its breaking on;

    Command attempted:

    create procedure [dbo].[sp_MSins_dbot_TABLEName_msrepl_ccs]

    @c1 int,

    @c2 int,

    @c3 int

    as

    begin

    if exists (select *

    from [dbo].[t_TABLENAME]

    where [TableID] = @c3)

    begin

    update [dbo].[t_TABLENAME] set

    [ItemID] = @c1,

    [DescriptorGroupID] = @c2

    where [TableID] = @c3

    end

    else

    begin

    insert into [dbo].[t_TABLENAME](

    [ItemID],

    [DescriptorGroupID],

    [TableID]

    ) values (

    (Transaction sequence number: 0x0000001900009E25006400000000, Command ID: 52)

    Error messages:

    String or binary data would be truncated. (Source: MSSQLServer, Error number: 8152)

    Get help: http://help/8152