In SQL Server 2008 release, a number of new collations were added. You can get the list of 79 new collations (only _CI_AS was listed) by using
select * from fn_helpcollations() where name like '%_100_ci_as'
These new collations are aligned with the linguistic sorting of Windows Server 2008 (they use very similar algorithm). In term of functionality, following new features are added:
LINGUISTIC_IGNORECASE in CompareString function to support b