sql server - Arithmetic overflow error converting IDENTITY to data type int -


arithmetic overflow error converting identity data type int, occurring when running through vb code. when execute stored procedure, data gets inserted properly.

through application works , doesn't.

when check current identity value , current column values different. falls under issue.

please let me know how solve it.

2147483647 maximum size int somewhere identity larger this. can use bigint instead around error, assuming identity won't surpass 9223372036854775807.


Comments