I was looking for some different information when I ran accross this thread.  I think that what you want is:

SELECT SERVERPROPERTY('SERVERNAME')

as this will provide server or server\instance information for you.

I am wondering about the statements regarding nocount.  I agree that it should be set on (not only for performance but because of problems with MS data access technologies throughout...