SQL Server 2005 - Descobrindo o collation do database (usando T-SQL)

Execute o seguinte script no Query Editor (SSMS):

SELECT DATABASEPROPERTYEX(‘AdventureWorks’, ‘Collation’)  SQLCollation;

O resultado será:

SQLCollation

————————————

SQL_Latin1_General_CP1_CI_AS