Welcome, Guest

How to Check the Version, Service Pack and Edition of Microsoft SQL Server on a Machine?

Options

Previous Topic

Next Topic

	codeling 1599 - 6654
	@2016-01-17 09:09:21

The following example shows returning the version information for the current installation.

SELECT @@VERSION AS 'SQL Server Version';

SQL Server Version

---------------------

Microsoft SQL Server 2012 - 11.0.5343.0 (X64) May 4 2015 19:11:32 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )

The @@VERSION Returns system and build information for the current installation of SQL Server.

SQL Server version
Processor architecture
SQL Server build date
Copyright statement
SQL Server edition
Operating system version

@2016-01-17 09:19:23

If you don't need the version information in your code, then you can get it in the SQL Server Management Studio.

Start SQL Server Management Studio and right clicking on the instance name and selecting properties. In the general section you will see information such as on the following screenshots.