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 of the procedure
and call the function thro linked server.
select * from OpenQuery(LinkeServername,'select * from batabase.dbo.funcname()')
In this case the function will return a TABLE data type which you
can access in your code.
Thanks,
Rahul