Displaying Collations

Obtain the currently used collation.

At the command prompt, enter:
SELECT * FROM SYS.SYSCOLLATION