Finding the Collations setting at database level and Server level

Finding the Collations Setting at Database Level.

Select name as database,

databasepropertyex(name,'collation')

from sys.sysdatabases

finding the collation Setting at instance level

Select Serverproperty('Collations')

The T-SQL script below will provide all of the details about a particular collation.

select * from fn_helpcollations where name='SQL_Latin1_General_CP1_CI_AS'

Thanks

A.S.Reddy