Have a read through this[/url].

110 is the compatibility level for SQL Server 2012. You need to change to it to ensure you can use all the new features.

You can check the server collation either on the Properties page for the server through the GUI, or by running this:

SELECT SERVERPROPERTY('Collation')

John