Hi chaps. A quick SQL query (awful pun intended) if I may please.

Can I have different Locales for each database on a SQL cluster? i.e. each database has it's own locale and timezone

OR (as I suspect)

Does MS-SQL Server take the locale from the underlying OS (Windows) or from the SYS database which manages the production databases.

SQL 2012 on Windows Server 2012.

Ta

Dom

not directly - you are right it just gets it from the OS.
However using UTC times with offsets will accomplish what you need probably.

see:

http://social.msdn.microsoft.com/Forums/sq...getstarted

look at the links in the answer with the blue tick against it.


also a worse pun...

a DBA walks into a bar and sees two sql queries sat at a table - he walks up to them and says "mind if I join you ?' Stephen
USA (originally from London) - 2005 L322 HSE

That's kind of where I'm getting to. There seem to be functions in .NET for offsetting against UTC which might do what I need.