Think i found it
@P9 varchar(567), P9 is snmp_oid and it is max 255
this is has been strange i removed it and will see if the issue is gone.
Code Select
exec sp_prepexec @p1 output,N'@P1 varchar(15),@P2 varchar(15),@P3 int,@P4 int,@P5 int,@P6 varchar(7),@P7 int,@P8 varchar(1),@P9 varchar(567)
@P9 varchar(567), P9 is snmp_oid and it is max 255
this is has been strange i removed it and will see if the issue is gone.