SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General / T-SQL to get all available instances on the server / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 09:52:28 GMT20RE: T-SQL to get all available instances on the serverhttp://www.sqlservercentral.com/Forums/Topic1396783-391-1.aspxThis renaming of a server article has a code snipet to find all the instances.http://craftydba.com/?p=1832Sat, 15 Dec 2012 20:46:42 GMTj.minerRE: T-SQL to get all available instances on the serverhttp://www.sqlservercentral.com/Forums/Topic1396783-391-1.aspxDECLARE @GetInstances TABLE( Value nvarchar(100), InstanceNames nvarchar(100), Data nvarchar(100))Insert into @GetInstancesEXECUTE xp_regread @rootkey = 'HKEY_LOCAL_MACHINE', @key = 'SOFTWARE\Microsoft\Microsoft SQL Server', @value_name = 'InstalledInstances'Select InstanceNames from @GetInstancesFri, 14 Dec 2012 13:07:20 GMTmadhankumar.rajendranT-SQL to get all available instances on the serverhttp://www.sqlservercentral.com/Forums/Topic1396783-391-1.aspxhi,can any body help me out on T-SQL to get all available instance names on the server.Fri, 14 Dec 2012 12:26:13 GMTZeal-DBA