Hi,
You can execute the stored procedure as following
exec [Linkedserver].databasename.dbo.usp_testing
I am getting problem inexecuting the query thro OPENQUERY
SELECT *
FROM OPENQUERY([Linkedserver],databasename.dbo.usp_testing)
So yOu can write a SQL Function Object on the top...