How can I findout what's my MSSQL server collation?

Question

Is there a SQL I can execute to find out?

Answer 1

The server default collation:

select serverproperty('collation')

Which is the same as

select databasepropertyex('master','collation')

Check SERVERPROPERTY in Books Online for other information you can get about the server (instance).