Is This Content Helpful?
We're glad to know this article was helpful.
ArcCatalog converts a column type Double(0,0) to column type Numeric 17(38,8) when using SQL Server. This can result in data not loading properly. Column type Double(0,0) should be converted to a Float(0,0).
This is a known issue.
Follow one of the workarounds below:
This may only work on an empty column. Data loss may occur if the column types are not compatible.
C:\>sdetable -o create -t NewTable -d "NewColumn1 float(0,0)" -i 5151 -s servername -D database -u test -p test
C:\>sdelayer -o add -l NewTable,shape -e s -g 100
0,0,0 -G 28355 -i 5151 -s servername -D database -u test -p test