How to: Modify Column Scale (Visual Database Tools)
The column scale refers to the maximum number of digits to the right of the decimal point for those columns of the decimal or numeric data types. By default, it is set to 0. For columns with floating point numbers, the scale is undefined because the number of digits to the right of the decimal point is not fixed.
You can change the scale for a numeric or decimal data type if you want to redefine the number of digits that can appear to the right of the decimal point.
In Object Explorer, right-click the table with columns for which you want to change the scale and click Design (Modify in SP1 or earlier).
The table opens in Table Designer.
Select the column for which you want to change the scale.
In the Column Properties tab, click the grid cell for the Scale property and enter a value for the scale.
Note: The Scale property applies to decimal or numeric types only.
The new scale is assigned to the column in Table Designer after you click outside the grid cell or use the TAB key to move to another grid cell. It takes effect in the database when you save your changes in Table Designer.