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/