Saturday, November 7, 2009

SQL Server Error 8115 Arithmetic overflow error converting numeric to data type varchar


Below error can happen when any field in the database is attempted to insert or update larger data of the same type or other data type. For example if an integer is attempted to insert in VARCHAR data type it will throw below error

Error:
Msg 8115, LEVEL 16, State 2, Line 2 
Arithmetic overflow error converting numeric to data type varchar.
The statement has been terminated. 

Fix/Resolution: 
Step 1: Verify the inserted/updated value that it is of correct length and data type. 

Step 2: If inserted or updated values are correct then modify the table to accommodated new data type length.
how to resolve msg 8115 error. how to resolve data type errors in sql server. how to find out correct length of the data type. how to find inserted value is correct length or not. data types in sql server. sql server data type issue. sql server data type error. arithmetic overflow. how to change data type in sql server. Arithmetic overflow error. how to resolve arithmetic overflow. how to solve arithmetic overflow.

0 comments:

Post a Comment