This seems like a basic question but I can't find any answers out there - I need to be able to get the server name/instance etc. from a linked server. I've tried a couple of things:

    select <linked server>.@@SERVERNAME;
    select <linked server>.SERVERPROPERTY('ServerName');

... but no joy. Any ideas?

This is SQL 2008 R2 & 2014 (2008R2 is the linked server)

EDIT: Errors are:

> Msg 102, Level 15, State 1, Line 2 Incorrect syntax near
> '@@SERVERNAME'.