All my money in dollars please?

I have a Windows 2003 server, with SQL 2005. How do i change the culture/regional options for the database as on my local test machine (which seems to be exactly the same in terms of windows regional settings and SQL server settings) the currenency fields show with a ￡ signs as expected, however on my production box they are $. I know this should be simple but its the night before a deadline and my brain is screwed. Please help!!

It 'should' be as simple as changing the regional settings using [Control Panel], [Regional and Language ...]

How is yours set?

|||

Everything is United Kingdom (except SQL Server Properties (installed language is English US but i have set login def language to British English (as fas as i was concerned that should be that) but still dollar signs and american date formats?

|||

Neil,

SQL Server does not 'store' currency symbols. From Books Online, Topic: 'Using Monetary Data':

SQL Server does not store any currency information associated with the symbol, it only stores the numeric value.

Displaying a dollar sign or a sterling sign is a function of the client application, often in conjunction with the OS Regional settings. You may wish to check the cultureUI settings for the application and verify that it is set to English-British. Otherwise, since it isn't really a SQL Server issue, I suggest that you may wish to post in one of the .NET related forums.

|||

OK, have done some more config checks, as follows

Windows 2003 Regional Options: All United Kingom (including server default)

SQL Server 2005 Region: United States

.NET Framework v2.x - Global en-GB Application en-GB

Application User (Database) British English

And it still shows the site in dollars, i have checked every bloody variable and setting i can think of, on my local box all i have to do is change the database user language and that is that, i can change ot as i see fot and the site locally reflects these changes, apply the exact same changes on the server and it soes nothing?

Help me obi-wan you're my only hope

|||

Since SQL Server is not the culprit here, it has to be some setting in your application. (For example, if you use SSMS, and you look at the raw data, you 'should' not see any currency symbol. If there is one stored, then the application is storing it as a character field with the currency symbol intact.)

This issue is in the presentation layer: IIS, Browser, .NET CultureUI setting, a format statement in the application.