How to identify SQL Server instances installed on local machine ?

Question

I have sql server 2000, 2005 exress, 2005, 2008 installed on my machine i installed on my own so there is no truble form me to know which on is on which version. However i am finding it difficult when i browse verious installation on others machine which i have not installed.

Can some one please help me regarding how to identify the instances on local machine and what version they are on.

Thanks

Answer 1

I'm not sure whether this is what you're asking for, but if you can connect to the instance, you can run the query:

SELECT @@VERSION

which should give you the information you require.

Answer 2

You can use the SQL Server Configuration Manager - it shows you information about the services for all local instances. Go to Start > SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager