Neil

  If you are using [money] as your data type, then you can't change
the scale.  The money type has a fixed scale of 4 decimal points.  If
you need a datatype that stores numbers with exactly 2 places after
the decimal, you can use decimal(10,2) or decimal(20,2) (the first
value is the total number of digits allowed, including those before and
after the decimal point).  You would have to change the data type of
the column, either with an ALTER TABLE .. ALTER COLUMN
statement, or with the visual table designer tool in Enterprise Manager.

  The data types money and decimal do not obey exactly the same
rules regarding rounding and arithmetic - if you are only adding,
subtracting, storing and retrieving data, I think they will be the same,
though.

Steve Kass
Drew University