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

I don't have a script for SQL Server 2005, but wanted to point out that this
becomes pretty easy with the SQL Server PowerShell provider that is included
in SQL Server 2008 when that releases later this year. You will be able to
launch the sqlps.exe custom shell, then just:

cd SQLSERVER:\SQL\MyComputerName
dir

You'll even be able to do scripts that can query any local computer it is
run on by using the localhost alias:

cd SQLSERVER:\SQL\localhost
dir

For more info on the level of PowerShell support that was in the SQL Server
2008 February CTP:
http://msdn.microsoft.com/en-us/libr...(SQL.100).aspx
http://msdn.microsoft.com/en-us/libr...(SQL.100).aspx

--
Alan Brewer [MSFT]
SQL Server Documentation Team

Download the latest Books Online update:
http://www.microsoft.com/technet/pro...ads/books.mspx

This posting is provided "AS IS" with no warranties, and confers no rights.