Creating a Case Sensitive Database in SQL Server.

Version 1

    Details

    Is it possible to create a case sensitive database in SQL Server?


    Resolution

    Run the following in SQL Management Studio altering the value of "Database_Name" with your database naming convention:


    USE MASTER

    GO

    CREATE DATABASE Database_Name COLLATE Latin1_General_CS_AS_KS_WS

    GO