May 15, 2008 at 8:17 am
Is anybody having t-sql or vbscript that can display the SQL Server instances installed on the machine?
Please share it if you have any such script.
Thanks,
Manu Jaidka
May 15, 2008 at 8:44 am
What time of information you want to know???
If you want to know the version use select @@version
for Service pack used select serverproperty('productlevel')
May 15, 2008 at 8:49 am
I want to view the SQL Server instances that are installed on the machine.
May 15, 2008 at 8:55 am
Go to registry-->software-->microsoft-->sql server-->instances...there you can find the instances installed in that particular machine.
Disclaimer:the path is not accurate
May 15, 2008 at 9:25 am
The Path you mentioned is not clear. Can you please repost this.
May 15, 2008 at 11:12 am
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\
"Got no time for the jibba jabba!"
-B.A. Baracus
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply