September 2, 2008 at 3:56 am
Hi
Guys
I have question regarding this instances ,How to find the installed instance's in server ,trough T-SQL is there any way.
Thanks
Ashwin VP
CSC India ...
September 2, 2008 at 6:55 am
xp_regread to enumerate the installed instances in the registry 😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2008 at 7:34 am
Hi,
You can check for my article on Enumerating SQL Instances throughout your LAN which is getting published on Sep 4. For this requirement you can use this code...
DECLARE @value VARCHAR(50)
EXEC master..xp_regread @rootkey = 'HKEY_LOCAL_MACHINE', @key = 'SOFTWARE\Microsoft\Microsoft SQL Server', @value_name = 'InstalledInstances', @value = @value OUTPUT
For TCP Port Use below key:
'SOFTWARE\Microsoft\Microsoft SQL Server\' + @@servicename + '\MSSQLServer\SuperSocketNetLib\Tcp'
Note:
Check whether you have permission to use xp_regread.. Also it is a undocumented SP!
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
September 2, 2008 at 8:20 am
Thanks you sir.
Ashwin VP
CSC India ...
April 20, 2010 at 7:22 am
April 20, 2010 at 8:14 am
mate, your keen this thread is over a year and a half old 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2010 at 8:18 am
Obviously so are you PerryP!
April 20, 2010 at 8:41 pm
May 19, 2011 at 1:34 pm
Thanks! It is saved my time....
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply