• try

    select serverproperty('ServerName')

    best regards,

    chris.