Hi

The following TSQL statement would also work (SQL Server 2005 and later):

SELECT collation_name FROM sys.databases WHERE name = N'MyDatabase'

Regards,

DigitalTeapot