This isn't a problem as I have already solved the problem, just trying to figure out why it happened.
Ok I have a field that is type money. I wrote a stored procedure that updates this field, however, I made the datatype for the parameter to get passed in a decimal instead. It was working fine for a while in the development environment. Then we restored the dev from a backup of production. I created the stored procedure the same as it was before, but now it is rounding off the field to the nearest whole number? I'm guessing it is a setting somewhere, but I can't imagine what.
Any ideas?
Like I said, this isn't an emergency, because I've already fixed it by changing the parameter in the stored proc to a money