Microsoft SQL Server Management Studio 17 doesn't get OS regional Setting

Question

I have configured comma (,) as the decimal separator character Regional Settings on my Windows 10 client.

However, the SQL Server Management Studio 17 grid view still display decimal separator as a period character (.).

When I save the grid output as csv file format and then open the file in MS Excel 2016, the column decimal values are automatically interpreted as date values and corrupted.

What is the solution to this problem?

If this is a bug, can Microsoft provide a patch?

Best regards

Frank Krogh

Answer 1

Due to the scope of your issue, your question is best redirected to the SQL Server forums on MSDN:

Msdn forums - SQL Server - MSDN - Microsoft

https://social.msdn.microsoft.com/Forums/sqlser...