Hello, I'm using SQL Server 7.0 (SP2) for my distributor and many subscribers. It seems that when I replicate using my subscribers, some of them hit the error "Arithmetic overflow error converting expression to data type int". However, I realised that after waiting for a while before replicating now, it seems okay. Anybody can advice how I can prevent this from happening? Thanks!

I've had no experience with replication, however an overflow normally means that you have a number that is larger than the is supported by the column. Do the data types match (int -> int, not int -> tiny int)?

regards
David Cameron