There are several ways to check the running SQL Server versions from Query Analyzer, command line, GUI and even by checking some binary file versions.
Output= Microsoft SQL Server 2005 – 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
Moreover you can check it from the below mentioned queries, open query analyzer and execute the below command.
Select SERVERPROPERTY(‘ProductVersion’) AS ProductVersion,SERVERPROPERTY(‘ProductLevel’) AS ProductLevel,SERVERPROPERTY(‘Edition’) AS Edition,SERVERPROPERTY(‘EngineEdition’) AS EngineEdition;
Output= 9.00.4035.00 SP3 Enterprise Evaluation Edition 3
3 = Enterprise (This is returned for Enterprise, Enterprise Evaluation, Data Center, and Developer.)
If you are bit reluctant 😉 to open query analyzer then fire a query then the version can also be checked from the server properties as mentioned below.
There is also another way to check for SQL Server version is from the SQL Server Configura tion Manager. Go to configuration manager and click Advanced Tab, then you can check for file version and version of the running SQL Server.
Sometimes if you have SCOM (System Centre Operation Manager) is monitoring your production server in your environment and you are getting still some alert that the SQL server version is not up to date even though it is updated, then you can check this from your SQLServr.exe version. To check this navigate to the location where your binaries are placed and then right click on SQLServr.exe file and check for Product version.
Note :- The SQL 2000 mainstream support was only available till April 08th 2008 and from then its extended support till April 09th 2013. If you need more details about this please follow the below mentioned Link by MS.
Note :- The SQL 2005 mainstream support was only available till 12 April 2008 and from then its extended support till 12 April 2016. If you need more details about this please follow the below mentioned Link by MS.
You can also check the version and patch level of your SQL Server from register
SQL Server Default Instance (2000)
SQL Server Default Instance(2005)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup
SQL Server Named Instance (2008)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.ONE\Setup