Look at SQL Queries to Get SQL Server Version & Edition

Sometimes, we might not know the version, edition etc of our installed SQL Server. We can follow anyone of the below method to get that information:

1. Run Select @@version within SQL Server Management Studio. It may show result similar to below:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)   Apr  2 2010 15:53:02   Copyright (c) Microsoft Corporation  Express Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)

This query returns information about the product, such as version, product level, 64-bit versus 32-bit, the edition of SQL Server etc.

2. Run SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('edition'), SERVERPROPERTY ('productlevel'), it shows result similar to below:

10.50.1600.1 Express Edition RTM

The difference between above two queries is, SERVERPROPERTY() returns individual selected properties where as @@version combines all properties into one string and returns it.

Ebook Download
View all
Learn
View all