How to determine the version and edition of SQL Server

Question: How to determine the version and edition of SQL Server?

Answer: Connect to the instance of SQL Server, and then run the following query: 

Select @@version

An example of the output of this query is as follows:

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009 
10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Express 
Edition (64-bit) on Windows NT 6.1  (Build 7600: )

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Thai_CI_AS"

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Thai_CI_AS" in the equal to operation.

Cause: Temp Table that was created by your sql statement use conflict collation with default collations of database or table you querying


Resolution: I install language in Control Panel > Regional and Language Settings for Thai then restart computer. After that, it works normally.