There may be a requirement to get exact name of any SQL Server instance. There are some ways to accomplish this task. Any of these ways can be usedn>
SELECT @@servername GO
Or system table sys.sysservers or sysservers may be queried to get the name of instance. However this table is contains one row for each server that an instance of SQL Server can access. So there may be records for linked servers in it.