T-SQL Query to find list of Instances Installed on a machine | SansSQL

Sunday, March 13, 2011

T-SQL Query to find list of Instances Installed on a machine

Here is a T-SQL Query to find the list of instances Installed on a machine.

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

OR

Create Table #GetInstances
( 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

drop table #GetInstances

Both the queries are almost similar, except for that first query uses a table variable and the second one uses temporary table.

4 comments:

markson said...

Before digging further into the subtleties of how to play video poker, what precisely are the advantages of playing the game? machine learning course

for ict 99 said...

Great Article
final year projects on machine learning

Final Year Project Centers in Chennai


JavaScript Training in Chennai
JavaScript Training in Chennai

mahil said...

Nice info..! Really superb and keep doing.....
Spark Training in Chennai
Spark Training Academy
Oracle Training in Chennai
Pega Training in Chennai
Graphic Design Courses in Chennai
Advanced Excel Training in Chennai
Soft Skills Training in Chennai
JMeter Training in Chennai
Tableau Training in Chennai
Unix Training in Chennai
Social Media Marketing Courses in Chennai

indomakmur said...

Woah! I’m really enjoying the template/theme of this blog. It’s simple, yet effective. A lot of times it’s challenging to get that “perfect balance” between user friendliness and appearance. I must say you’ve done a excellent job with this. Also, the blog loads very quick for me on Safari. Superb Blog! https://royalcbd.com/product/cbd-gummies-25mg/

Post a Comment

Ads