You can use the fn_helpcollations() function to return the list of all collations that are supported by Microsoft SQL Server 2005 If you run the below sql statement you will get the list.
select * from fn_helpcollations()
The first column "Name" is the standard collation name and the second column is a description of the collation. You can run the below sql statement to get the list of all collation which support Turkish.
SELECT name, description FROM fn_helpcollations() WHERE name like '%Turkish%'
In SQL Server 2000 ::fn_helpcollations() function is the equivalent function of fn_helpcollations() for SQL Server 2005
SELECT name, description FROM ::fn_helpcollations() WHERE name like '%Turkish%'