Find Version of SQL Server
There are various ways to find out version of SQL Server being used. I will list two of them which are commonly used.
Its the easiest way to find out version of SQL Server. Open SQ Server Management Studio and connect to local or remote instance of SQL Server database. Go to Object Explorer, right click on instance name of SQL Server on select ‘Properties’. This will open Server Properties window where you can see complete details of SQL Server, including version.
In case you don’t have access to Management Studio, you can always use T-SQL to find out version of SQL Server.
Run following query:
In result, you will get very descriptive information about SQL Server such as following:
Microsoft SQL Server 2008 (RTM) – 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Express Edition with Advanced Services (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)