Arithmetic overflow error converting expression to

spikey · June 24th, 2003, 04:38 AM

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!

David Cameron · June 24th, 2003, 07:19 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
simple arithmetic overflow vbscript	handy	Classic ASP Basics	32	March 31st, 2009 04:25 PM
Arithmetic overflow error	gregalb	Reporting Services	1	June 24th, 2008 02:42 PM
Odd arithmetic overflow error....	7racer	SQL Server 2000	4	May 12th, 2006 09:17 AM
arithmetic overflow problem	flyfish	SQL Server 2000	4	July 12th, 2005 04:37 PM
Arithmetic overflow error converting expression to	sinapra	Classic ASP Databases	8	September 3rd, 2004 12:24 AM