[FAQ][SQL2008] Is there an easy way to see which SQL Instances have been configured on a SQL 2008 Server?
A couple of ways I've found are: Look at the SQL Service names which contains the instance name: For example if SQL has been installed to the Default instance the service name will be: SQL Server (MSSQLSERVER) If SQL has been installed to an instance
Read More...
Read the complete post at http://myitforum.com/cs2/blogs/chobbs/archive/2010/08/31/faq-sql2008-is-there-an-easy-way-to-see-which-sql-instances-have-been-configured-on-a-sql-2008-server.aspx