How to determine the version of SQLServer that is booting

Asked 1 years ago, Updated 1 years ago, 68 views

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


© 2024 OneMinuteCode. All rights reserved.