I always assumed collations appended the special characters to a basic character set like ascii instead of interweaving with(or totally rearranging) it. Thanks for the education!

Something like @@remserver... but for linked servers.

@@remserver works fine right now but is to be deprecated in SS2008, so I can't use it.

I checked MSDN and there is no replacement...