How to Change Database Collation From Case Insensitive to Case Sensitive - SQL Server DBA Tutorial

In this video you will learn how to change SQL Server Database collation from Case Insensitive to Case sensitive using SQL Server Management Studio as well as using T-SQL Script. It also talks about best practices and cautions of changing Collation from Case Insensitive to case sensitive.

Script to Change Collation of Database in SQL Server

USE [master]
GO
ALTER DATABASE [Demo] COLLATE SQL_Latin1_General_CP1_CS_AS
GO


How to Change Database Collation From Case Insensitive to Case Sensitive - DBA Tutorial