How do I find out what collations are available in SQL 2000/2005

Question

If I need to choose a collation mode to work with, how do I know what collations are available?

Answer 1

Use this query to list the available collation modes:

SELECT * FROM fn_helpcollations()

Answer 2

select distinct COLLATION_NAME from INFORMATION_SCHEMA.COLUMNS order by 1