Blog Post

SQL Server Collation

,

Instead of just right clicking on SSMS , these are some alternatives to locating SQL Server Collation information I use.

 

--To find all collations available 
SELECT * FROM fn_helpcollations()
--To find the SQL Server Collation level 
select SERVERPROPERTY('collation')
--To find the database collation level 
SELECT DATABASEPROPERTYEX('MyDatabase', 'Collation') as DB_SQLCollation;

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating