SQL Server relies on the Windows default value of 1 (one) for this key.
Note As soon as this key is set to 0 (zero) on a system on which SQL Server is installed, the operation of setting the key back to 1 (one) is not a tested scenario for SQL Server. Additionally, this behavior is not supported. Therefore, we recommend a clean reinstallation of SQL Server on a server on which this key has never been changed.
For more information, see How to configure case sensitivity for file and folder names.
Article ID: 2860895 - Last Review: Jun 26, 2013 - Revision: 1