How To List How Many SQL Server Instances Installed in the Server

Published: 19 October 2022
on channel: MS SQL DBA Tech Support

422

--Script:
DECLARE @intstances TABLE
( Value nvarchar(100),
InstanceNames nvarchar(100),
Data nvarchar(100))
Insert into @intstances
EXECUTE xp_regread
@rootkey = 'HKEY_LOCAL_MACHINE',
@key = 'SOFTWARE\Microsoft\Microsoft SQL Server',
@value_name = 'InstalledInstances'
Select InstanceNames from @intstances

Watch video How To List How Many SQL Server Instances Installed in the Server online, duration hours minute second in high quality that is uploaded to the channel MS SQL DBA Tech Support 19 October 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 422 times and liked it 5 visitors.

10,484