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
11,017 times
Add to favorites
E-mail Twitter 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:
      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.