• Use OPENQUERY

     

    SELECT * FROM OPENQUERY (LINKEDSERVERNAME,'SELECT GETDATE() AS CUR_DATE')