Determining the version of SQL Server installed components by PowerShell

In SQL Server, can only use master.dbo.xp_regread procedure reading registries to get components version information, some enterprises in order to safely remove the procedure. So, in this chapter, we will use PowerShell to determine the version of SQL Server installed components.

 
 
 
 
 
3 Star
(6)
10,588 times
Add to favorites
Databases
12/14/2015
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • Script gives false info!
    1 Posts | Last post August 28, 2018
    • Content of 
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL13.<instancename>\MSSQLServer\CurrentVersion\CurrentVersion:
      13.2.5026.0
      
      SELECT @@VERSION returns: Microsoft SQL Server 2016 (SP2-CU2) (KB4340355) - 13.0.5153.0 (X64)   Jun 28 2018 17:24:28   Copyright (c) Microsoft Corporation  Developer Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor) 
  • This is only if there's a database engine installed
    1 Posts | Last post September 16, 2016
    • It won't work if it's a server with standalone components only, like SSAS/SSRS/SSIS/MDS clients, etc.