>>I've tried in the command window
>>PING MyServerName
>>
>>Found this also http://stackoverflow.com/questions/142142/sql-query-to-get-servers-ip-address, but it refers to IP Address of the computer as it invokes IPConfig
>
>PING MyServername works. However my SQL Server name is the same as the computer. But this is what I was looking for. Thank you.

I also have the same name for SQL Server as my computer. Sounds like a good idea next time I'll install SQL Server to give it a different name.

BTW, new version of SQL Server (Code name Denali) has been announced and given people at PASS conference:

New SQL Server announced at PASS