August 30, 2012 at 8:22 am
I have job running every day got failed because of following error
Arithmetic overflow error converting IDENTITY to data type int. [SQLSTATE 22003] (Error 8115) Arithmetic overflow occurred. [SQLSTATE 01000] (Error 3606). The step failed.
please guide me
August 30, 2012 at 8:57 am
Hope your identity int column as reached its limit.
Regards
Durai Nagarajan
August 30, 2012 at 2:01 pm
Alter Table Alter Column your identity column to BIGINT, you've got more than 2 billion entries !!!
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply