How to Find the SQL Server Version

Question

Post reply

How to Find the SQL Server Version

Nisarg Upadhyay

SSC-Addicted

Points: 460
More actions
June 23, 2023 at 12:00 am

#4214548

Comments posted to this topic are about the item How to Find the SQL Server Version
June 24, 2023 at 7:29 pm

This was removed by the editor as SPAM

July 19, 2023 at 4:32 pm

This was removed by the editor as SPAM
August 22, 2023 at 11:53 am

This was removed by the editor as SPAM
August 27, 2023 at 10:37 am

This was removed by the editor as SPAM
August 27, 2023 at 10:42 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

mr.jim Grasshopper Points: 12 More actions · Answer 1

hi,

nice post

can you do the same for analysis server version

thanks

This reply was modified 1 year, 5 months ago by mr.jim.

peter.row SSCarpal Tunnel Points: 4319 More actions · Answer 2

Knowing the version is not nearly as important as knowing where it is say SQL 2014, 2017, 2019 etc... and what service pack is applied.

Knowing that it's say 15.2.3459 doesn't convey anything on its own because you then have to go look up what they version means.

Michael L John One Orange Chip Points: 27059 More actions · Answer 3

peter.row wrote:

Knowing the version is not nearly as important as knowing where it is say SQL 2014, 2017, 2019 etc... and what service pack is applied.
Knowing that it's say 15.2.3459 doesn't convey anything on its own because you then have to go look up what they version means.

Oh, so how can that be done?

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Nisarg Upadhyay SSC-Addicted Points: 460 More actions · Answer 4

Hello Everyone, Thanks for your valuable feedback. I will make changes in the article accordingly as soon as possible.

Nisarg Upadhyay SSC-Addicted Points: 460 More actions · Answer 5

Sure. I will add that in revised version of article.

peter.row SSCarpal Tunnel Points: 4319 More actions · Answer 6

It was one of the way

Michael L John wrote:

peter.row wrote:
Knowing the version is not nearly as important as knowing where it is say SQL 2014, 2017, 2019 etc... and what service pack is applied.
Knowing that it's say 15.2.3459 doesn't convey anything on its own because you then have to go look up what they version means.
Oh, so how can that be done?

It was mentioned in the article as one of the ways, but in short simply running the following SQL query is the way I use when I want to know:

select @@version

For example, on my local SQL 2014 Developer edition it tells me, so it tells you which SQL Server edition, service pack, bit-ness, as well as the mostly useless version number.

Microsoft SQL Server 2014 (SP3-GDR) (KB5021037) - 12.0.6174.8 (X64) Jan 4 2023 08:59:45 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.3 <X64> (Build 22621: ) (Hypervisor)

greg_spielman Newbie Points: 5 More actions · Answer 7

This should give you everything you would ever want. I use it to populate several columns of my instance inventory table.

select
right((left(@@VERSION,25)),15) as 'ProductVersionName'
,SERVERPROPERTY('ProductLevel') AS 'ProductSpLevel'
,SERVERPROPERTY('ProductUpdateLevel') AS 'CumulativeUpdateLevel'
,SERVERPROPERTY('ProductUpdateReference') AS 'KbArticle'
,SERVERPROPERTY('Edition') AS 'ProductEdition'
,SERVERPROPERTY('ProductVersion') AS 'ProductFullRevisionVersion'
,SERVERPROPERTY('ProductMajorVersion') AS 'ProductMajorVersion'
,SERVERPROPERTY('ProductMinorVersion') AS 'ProductMinorVersion'
,SERVERPROPERTY('ProductBuild') AS 'ProductBuildNum'
,SERVERPROPERTY('ProductBuildType') AS 'ProductBuildType'

gulshan212 SSC Enthusiast Points: 194 More actions · Answer 8

Hello, this is Gulshan Negi

Well, there are various ways to find the version of Microsoft SQL Server:

Using SQL Server Management Studio (SSMS) by right-clicking on the server name in the Object Explorer and selecting Properties.

2. Using the Windows Registry by navigating to the appropriate registry key and checking the "CurrentVersion" value.

3. Using the command prompt by executing the command sqlservr.exe -v in the SQL Server installation directory.

You can quickly determine which version of Microsoft SQL Server is installed on your system by using one of these methods.

I hope it will help you.

Thanks

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 9

Hi.

Thanks for posting PS script for fetching SQL version.

Invoke-Sqlcmd -ServerInstance "Servername" -Query "Select @@version as SQLVERSION"

I want to store output in sql server table like servername, version column from multiple server names. please post the script if any.

Thanks

This reply was modified 1 year, 4 months ago by SQL Galaxy.