What Version of SQL Server Is Running ?
When you sit down for the first time with a new SQLServer instance its a good idea to validate precisely what version you have running. I have been told I have one version when in fact I have another. In large installations of servers its even possible you may have forgotten what a particular server is running.
First you can view the SQL Log “Management->Sqlserver Logs->…. the first record will usually show the server name. You may have to widen the column to see it all.
Another way is to use the @@VERSION variable. Instead of using SELECT @@VERSION which returns the results in a single text column I prefer to use PRINT @@VERSION which formats the output in a more human readable display.
Microsoft SQL Server 2014 – 12.0.2000.8 (X64)
Feb 20 2014 20:04:26
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
In the above example it shows I am using the 64 bit version of SQLSERVER 2014 Standard Edition