We are running sql 2005 (cluster). I notied that our dev servers collation is set to LATIN1_GENERAL_CI_AI, but production is set to SQL_LATIN1_GENERAL_SP1_CI_AS.
For what I could find:
latin1_general = U.S english...
CI_AI: case-insensitive, accent insensitive, kana insensitive, width insensitive
CI_AS: same as above, but accent sensitive.
What does the CP1 indicate and the 'SQL' on the production collation.