Get Installed SQL Server Instance on a Server

 

Developed the script to get installed SQL Server Instance on a Server. To run this script user should have admin privileges or minimum permission to read OS registry on the server.

DECLARE @Registry_Value VARCHAR(1000) DECLARE @SQL_In AS TABLE (Id NVARCHAR(MAX),InsName NVARCHAR(25))   INSERT INTO @SQL_In(Id,InsName) EXECUTE xp_regread ‘HKEY_LOCAL_MACHINE’,‘SOFTWARE\Microsoft\Microsoft SQL Server’,‘InstalledInstances’, @Registry_Value OUTPUT   SELECT @@ServerName [Server Name],InsName [Installed SQL Instance] FROM @SQL_In