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

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

--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.