SQL Server Transact Basic to Expert - View Collation Metadata

This blog shows how to view the SQL Collation metadata from the query analyzer

Syntax:

SELECT SERVERPROPERTY('Collation')