How to query the version number and other information related to SQL Server ?

Sometimes, you might want to query the  SQL Server version to know its exact version number and other information like Platform, Product Name etc.

Here’s a simple stored procedure in SQL Server that helps to retrieve not just the SQL Server version but also additional information about the SQL Server.


Query to retreive the SQL Server Information */

EXEC xp_msver


The xp_msver returns not just the version number, but also other SQL Server related information like

1    ProductName    NULL    Microsoft SQL Server

2    ProductVersion    720896    11.0.2100.60

3    Language    1033    English (United States)

4    Platform    NULL    NT x64

5    Comments    NULL    SQL

6    CompanyName    NULL    Microsoft Corporation

7    FileDescription    NULL    SQL Server Windows NT – 64 Bit

8    FileVersion    NULL    2011.0110.2100.060 ((SQL11_RTM).120210-1917 )

9    InternalName    NULL    SQLSERVR

10    LegalCopyright    NULL    Microsoft Corp. All rights reserved.

11    LegalTrademarks    NULL    Microsoft SQL Server is a registered trademark of Microsoft Corporation.

12    OriginalFilename    NULL    SQLSERVR.EXE

13    PrivateBuild    NULL    NULL

14    SpecialBuild    137625660    NULL

15    WindowsVersion    602931718    6.2 (9200)

16    ProcessorCount    8    8

17    ProcessorActiveMask    NULL     ff

18    ProcessorType    8664    NULL

19    PhysicalMemory    8124    8124 (8519024640)

20    Product ID    NULL    NULL

Note that I am using SQL Server 2012 for trying out the above query 🙂

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


Interesting BlogPosts to read

Column Alias and Square brackets in SQL Query.
When we want to specify a alias for a column in SQL Query , we tend to use the double quotes or sing...
C# Program to Display the Reverse of a Number
Introduction This program in C# developed using .NET Framework , C# and Visual Studio  will demonst...
How to get the MAX row with group by in LINQ query using C# ?
Below is a sample code snippet demonstrating how to retreive the max row with the group by in LINQ Q...