Msg 451, Level 16, State 1, Line 1
Cannot resolve collation conflict between"Latin1_General_100_CS_AS"and"Latin1_General_CI_AI"inUNIONALL operator occurring inSELECT statement column 1.
select geography::CollectionAggregate ( SpatialLocation ).ToString()
where City = 'Sydney'unionallselect SpatialLocation.ToString()
where City = 'Sydney'
Latin1_General_100_CS_AS is the database collation and the server collation is Latin1_General_CI_AS so where does Latin1_General_CI_AI come from and why would the ToString() methods return different collations?