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
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
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.