Arabic Collation in SQL 2005

Arabic_CI_AS is the test collation, and being used in my work environment.

This white paper is helps a lot ..

http://technet.microsoft.com/en-us/library/cc295829%28SQL.90%29.aspx

Gives you a detailed overview of the Arabic collation.