Here is the handy query to identify the Collation settings on the Server.
SELECT SERVERPROPERTY('Collation') The output is,
Latin1_General_CI_AI It indicates my server will support Latin general language, with Case insensitivenss and Accent insensitiveness.
Cheers,
Venkatesan Prabu .J
Head -
http://www.kaashivinfotech.com/ http://venkattechnicalblog.blogspot.com/