How can I findout what's my MSSQL server collation?

Is there a SQL I can execute to find out?

  • How to build RUNAS /NETONLY functionality into a (C#/.NET/WinForms) program?
  • (Common Table Expressions) CTE as part of WHERE clause… possible?
  • How to remove the time portion of a datetime value (SQL Server)?
  • Error connecting to SQL Azure Database
  • SQL Server returns error “Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.” in Windows application
  • 3 Solutions collect form web for “How can I findout what's my MSSQL server collation?”

    The server default collation:

    select serverproperty('collation')

    Which is the same as

    select databasepropertyex('master','collation')

    Check SERVERPROPERTY in Books Online for other information you can get about the server (instance).

    SELECT DATABASEPROPERTYEX('AdventureWorks', 'Collation') SQLCollation;

    Just substitute your DB name for 'AdventureWorks'. Or use DB_NAME:


    This is the official doc given by MS, hope it helps.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.