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?
  • SQL LIKE % FOR INTEGERS
  • (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:

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

    This is the official doc given by MS, hope it helps.
    http://msdn.microsoft.com/en-us/library/hh230914.aspx#TsqlProcedure

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