When you try to create a decimal attribute that has 16 digits precision by doing:
MetadataAttribute newAttribute = new MetadataAttribute();
newAttribute.DataType = AttributeDataType.Number;
newAttribute.DataTypeInformation = 16;
A column is created that has the correct Scale of 16 and incorrect Precision of 22.
- For SQL Server 2014, apply the fix.
- For SQL Server 2012, change the stored procedures to use a constant value of 38 (max allowed by SQL Server 2012) instead of subtract scale (@DataTypeInformation, and so on) from the Precision.
Article ID: 2929832 - Last Review: 21 Apr 2014 - Revision: 1