What Version of SQL Server Is Running ?

by bitznbitez

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

Advertisements