ALTER DATABASE database COLLATE Latin1_General_CI_AS
SELECT
[name]
,COLLATIONPROPERTY([name], 'CodePage') AS [CodePage]
,COLLATIONPROPERTY([name], 'LCID') AS [LCID]
,COLLATIONPROPERTY([name], 'ComparisonStyle') AS [ComparisonStyle]
,COLLATIONPROPERTY([name], 'Version') AS [Version]
,[description]
FROM ::fn_helpcollations()
where name like 'Lat%'
