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