Recently I was searching for the Instance Name of My SQL Server Installed long time back.  I found a very quick way to get that in form of a query.


Just type in the following above query and you will come to know about the Instance Name along with the various other facts related to your SQL all starting with @@


Thanks !!!