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

codeling 1236 - 5298
@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

codeling 1236 - 5298
@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.

codeling 1236 - 5298
@2016-01-17 09:33:21

The SERVERPROPERTY function returns property information about the server instance.

Run the following query in your SQL Server:

SELECT SERVERPROPERTY('productversion') as 'Version',

       SERVERPROPERTY ('productlevel') as 'Service Pack',

       SERVERPROPERTY ('edition') as 'Edition';


Version       Service Pack  Edition

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

11.0.5343.0   SP2            Enterprise Edition (64-bit)


Users browsing this topic