The SQL below generated by TOAD during an attempted schema compare has a defect:
IDENTITY attribute columns can exist on NUMERICS up to 38 digits wide.
System.ApplicationException
Read data from database.
Gathering information for Checks error. Error:Script Columns failed. Error: Arithmetic overflow error converting expression to data type bigint.
WORKAROUND:
None
STATUS:
Waiting for fix in a future version of Toad for SQL Server.
Recreation of the problem:
1. Create a table with a primary key defined NUMERIC(38,0) and IDENTITY attribute.
2. Set the initial value to 38 8’s using DBCC CHECKIDENT (for example)…
3. Add a row to the table to confirm next value is very large
4. Try a schema compare or data compare
