exec ServerName.master.dbo.sp_executesql N'Select SERVERPROPERTY(''MachineName'')'--or if you are calling a function that exists on the server:SELECT * FROM OPENQUERY(LINKEDSERVER1,'SELECT dbo.T_DATE(''D'')')