Error 1002
Severity Level 16
Message Text
Line %d: Specified scale %d is invalid.
Explanation
This error occurs when the scale of a decimal or numeric column does not fall between the allowable minimum and maximum values based on the precision of the column.
Action
Specify the precision with p, which must be between 1 and the maximum precision, and the scale with s, which must be between 0 and p. If you do not specify the precision, Microsoft® SQL Server™ uses a default precision of 18. If you do not specify the scale, SQL Server uses a default scale of 0. For more information, see the decimal and numeric topic and the Precision, Scale, and Length.