I have created 5 replica SQL Servers for testing. Each of these, the installation defaults to Language 0 (US English). I have set the configuration on ALL servers to be 23 (British English).
However, queries are all failing as they are trying to run as mm/dd/yyyy rather than dd/mm/yyyy on dates. You can get round this by stating SET LANGUAGE 'British English' on each SQL Session. We can't edit 5,000+ stored procs, and I don't think we should have to!
How can I get the language to set in stone?