You can execute below script to check whether SQL Server is case sensitive or not
SELECT case when 'a' <> 'A' then 'Case-Sensitive' else 'case-insensitive' end AS 'Case Sensitivity'
You can execute below script to check whether SQL Server is case sensitive or not
SELECT case when 'a' <> 'A' then 'Case-Sensitive' else 'case-insensitive' end AS 'Case Sensitivity'
Easy way hah!! I like it..