By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
I am using the money data type in SQL Server 2000. When I display values on my production server (using ASP.NET), it shows two places after decimal, but on the live server it shows four digits after the decimal. What setting is required to get this rectified on my live server?
That is because your ASP.NET application is rounding them off. Money values are stored with 4 decimal places and you can find this explicitly documented in Books Online.