You can find the information related to that use following codes.
1. To findout "SERVER NAME"
SELECT SERVERPROPERTY('MACHINENAME')
2. To findout "SERVER NAME" with "INSTANCE NAME" (If its Named Instance)
SELECT SERVERPROPERTY('SERVERNAME')
3. To findout "CLIENT MACHINE NAME"(Local Machine Name)
SELECT HOST_NAME()