How to determine the version of SQLServer that is booting

I am in charge of information systems that operate servers in the company.
If anyone has any knowledge of the subject, please let me know.

There are 3 versions of SQLServer (2008, 2012, 2014) installed in the server currently in operation.
"For some reason, a command was issued to ""uninstall SQLServer that is not currently in use"", and I have checked many things, but I don't think I can identify it with a small job..."

Is there a way to check and identify the version that is booting from Windows?
Or do I have no choice but to contact the application source running on the server?

sql windows-server

2022-09-30 16:37

1 Answers

Assuming that the SQL server is not duplicated, there seems to be a quick way to connect to the SQL server to see the results of the following queries:

How to Verify the SQL Server Version

Run the following SQL commands to obtain SQL Server product name, product version, deployment date, edition, OS version and edition information as a result.

SELECT@@VERSION

(Example Results)

Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64) Oct 28 2016 18:17:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2016 Standard 6.3<X64> (Build 14393:) (Hypervisor)

2022-09-30 16:37

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656