This blog shows how to get the current sessions Server Instance name in SQL Server

Example:

SELECT @@SERVERNAME Server Name