How To List How Many SQL Server Instances Installed in the Server
--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 without registration, duration hours minute second in high quality. This video was added by user MS SQL DBA Tech Support 19 October 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 422 once and liked it 5 people.