TechBrothersIT is the blog spot and a video (Youtube) Channel to learn and share Information, scenarios, real time examples about SQL Server, Transact-SQL (TSQL), SQL Server Database Administration (SQL DBA), Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Warehouse (DWH) Concepts, Microsoft Dynamics AX, Microsoft Dynamics Lifecycle Services and all other different Microsoft Technologies.
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
GOALTERDATABASE [Demo] COLLATE SQL_Latin1_General_CP1_CS_AS
How to Change Database Collation From Case Insensitive to Case Sensitive - DBA Tutorial