How to find the SQL Database Collation.

Version 1

    Details

     

    What is the syntax for finding the collation of a SQL Server database?

     


    Resolution

    Run the following in SQL Server Management Studio replacing your database named for the Database_Name value:

    SELECT DATABASEPROPERTYEX('Database_Name', 'Collation')