T-SQL to get all available instances on the server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » T-SQL to get all available instances on the...

T-SQL to get all available instances on the server

Rate Topic

Display Mode

Topic Options

Author

Message

Zeal-DBA

Posted Friday, December 14, 2012 12:26 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:11 AM
Points: 185, Visits: 941

hi,
can any body help me out on T-SQL to get all available instance names on the server.

Post #1396783

madhankumar.rajendran

Posted Friday, December 14, 2012 1:07 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:39 AM
Points: 31, Visits: 37

DECLARE @GetInstances TABLE
( Value nvarchar(100),
InstanceNames nvarchar(100),
Data nvarchar(100))

Insert into @GetInstances
EXECUTE xp_regread
@rootkey = 'HKEY_LOCAL_MACHINE',
@key = 'SOFTWARE\Microsoft\Microsoft SQL Server',
@value_name = 'InstalledInstances'

Select InstanceNames from @GetInstances

Post #1396800

j.miner

Posted Saturday, December 15, 2012 8:46 PM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:07 AM
Points: 79, Visits: 278

This renaming of a server article has a code snipet to find all the instances.

http://craftydba.com/?p=1832

John Miner
Crafty DBA
www.craftydba.com

Post #1396959

« Prev Topic | Next Topic »

Permissions