Raghavender (9/13/2011)
Hi All,How to find out Installed SQL Server Instances and their names on a server using T-SQL or any other way ?
The easiest way for me is, go to services and check the sql server services.
If its named instance then your sql service will be named as mssql$instancename, if its default instance then simply mssqlserver.
----------
Ashish