-- List SQL Server default collation
sp_helpsort
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data
select SERVERPROPERTY('Collation')
SQL_Latin1_General_CP1_CI_AS
-- Find a collation name of users database
SELECT CONVERT (varchar, DATABASEPROPERTYEX('database_name','collation'))
eg:
-- find master database collation
SELECT CONVERT (varchar, DATABASEPROPERTYEX('master','collation'))
--List out all Collations
SELECT * from ::fn_helpcollations()
