June 7, 2006 at 1:55 am
Hi Gurus,
I get this error upon running our maintenance jobs. Can anybody advice me .. what this is?
[Microsoft SQL-DMO (ODBC SQLState: 22003)] Error 220: [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for data type smallint, value = 65535.
[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for data type smallint, value = 65535.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
1000 and 1 thanks
Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me
June 8, 2006 at 7:32 am
| Data type | Range | Storage |
|---|---|---|
bigint | -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807) | 8 Bytes |
int | -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647) | 4 Bytes |
smallint | -2^15 (-32,768) to 2^15-1 (32,767) | 2 Bytes |
tinyint | 0 to 255 | 1 Byte |
Looks like a data issue. You don't specify what your maintenance job does, but it looks like it is calculating a value that exceeds what a smallint column can handle..
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply