After you finish installation for SQL server may be you want to change the Server collation or database Collation so leat’s see what will we do if we want to make this :
1- if you want to know what’s your database collation know
SELECT name, collation_name
FROM sys.databases WHERE name = ‘test’ — put your database name here
2- If you want to get a list of all available collations on the server using
SELECT * FROM ::fn_helpcollations()
3- Alter Database Collation
ALTER DATABASE test — put your database name here
COLLATE Arabic_CI_AS — replace with whatever collation you need
4- IF you want to know what’s your server collation
SELECT SERVERPROPERTY (‘Collation’)
Published by Mustafa EL-Masry
I am Microsoft database consultant working as a Database administrator for more than +10 Years I have very good knowledge about Database Migration, Consolidation, Performance Tuning, Automation Using T-SQL, and PowerShell and so many other tasks I do it in multiple customers here in KSA and as of now, I am working in Bank Albilad managing the core banking system that is hosted in SQL Server Database 8 TB. Also, I am Microsoft certified 2008 and 2016 in SQL Server (2x MCTS, 2x MCTIP, MCSA, MCSE) and I am Microsoft Certified Trainer (MCT) also I am azure Certified (AZ-900, AZ-103) also I was awarded by Microsoft Azure Heroes 3 times as (Azure Content hero, Azure Community hero and Azure Mentor) For more information check my page
View all posts by Mustafa EL-Masry
One thought on “Change The Server Collation after installation”
Can check for this is best option.above will change only for single database.
server level collation change needs reinstall of SQL or rebuilding system databases.
database level collation can be changed by database properties but that doesn’t change collation of objects in database.
Following link will give you clear Idea.