SELECT 
	ORIGINAL_LOGIN() [current login]
	,CAST(s.server_id AS INT) AS [ID]
	,s.is_linked
	,s.name AS [Linked Server]
	,s.data_source
	,s.modify_date AS [Server Modified]
	,CASE 
		WHEN ll.uses_self_credential = 1
			THEN '[Current security context]'
		ELSE ll.remote_name
		END AS [Login Used]
	,ll.modify_date AS [Login Modified]
	,ISNULL(s.CATALOG, N'') AS [Catalog]
	,ISNULL(s.location, N'') AS [Location]
	,s.product AS [ProductName]
	,s.provider AS [ProviderName]
	,CAST(s.is_collation_compatible AS BIT) AS [CollationCompatible]
	,CAST(s.is_data_access_enabled AS BIT) AS [DataAccess]
	,CAST(s.is_remote_login_enabled AS BIT) AS [Rpc]
	,CAST(s.is_rpc_out_enabled AS BIT) AS [RpcOut]
	,ISNULL(s.collation_name, N'') AS [CollationName]
	,s.connect_timeout AS [ConnectTimeout]
	,s.lazy_schema_validation AS [LazySchemaValidation]
	,s.query_timeout AS [QueryTimeout]
	,s.uses_remote_collation AS [UseRemoteCollation]
FROM sys.servers s
LEFT JOIN sys.linked_logins ll ON ll.server_id = s.server_id

/* выполнить на Server2 */
use tempdb 
go

create proc dbo.ret_val (@in nvarchar(128)) 
as 
  select @in [parameter]
go

grant exec on dbo.ret_val to public
go

/* выполнить на Server 1*/
exec Server2.tempdb.dbo.ret_val @@servername
exec Server2.tempdb.dbo.ret_val N'test value'

/* удаление процедуры */
/* выполнить на Server2 */
use tempdb 
go
drop proc dbo.ret_val
go