What is My SQL Server Collation Set To?

To find out what the collation settings are in an instance of SQL Server, open a New Query window and execute the following command:

SELECT CONVERT (varchar, SERVERPROPERTY('collation'));


It will return the collation setting, for example:  SQL_Latin1_General_CP1_CI_AS