> Will a decimal(9,2) maintain the trailing zeros on say, a monetary

value?

No it won't, 10.10 = 10.1, it can be simply formatted on the client end.

You could make a UDF function to return a formatted string of a
decimal if you liked, but personally I wouldn't bother.