I have a program that uses the MSSQL database. Recently I tried changing my
regional settings to something other than US. I tried France, its currency
is 0,00 not 0.00.

In my code I do the following:
UPDATE tblChargeTenant SET Discount=0,00 WHERE ChargeTenantID=15

This gives me an error 'Incorrect syntax near '00'

This is the same error message when it is run in Query Analyzer.

I set the RegionalSettings to France in both the client and the server. How
do I tell SQLServer to respect the RegionalSettings?

I found a reference to SQL_SOPT_SS_REGIONALIZE in Books On Line but I do not
know how to use it.

Thanks,
Rob