SQL Server Transact Basic to Expert - Get Collation complete description

This blog show how to get the complete description of the collation using the query analyzer

Syntax:

SELECT description FROM sys.fn_helpcollations() WHERE name = 'SQL_Latin1_General_CP1_CI_AS'