By default all MS SQL database users you create in our control panel are set to British - English as we are a British company.
Sometimes clients may experience issues with date formats due to the difference between country date formats and the fact that many free or commercial applications are designed for US date formats.
You can change the Default Language of your database user by running the following SQL queries against your database.
We recommend you use SQL Server Management Studio (SSMS) to do this.
Simply change [UserLogin] to your MS SQL database username.
Change to US format Default Language:
ALTER LOGIN [UserLogin] WITH DEFAULT_LANGUAGE=[us_english]Change back to British / UK format Default Language:
ALTER LOGIN [UserLogin] WITH DEFAULT_LANGUAGE=[British]
