This site is hosted and sponsored by hyve.com specialists in Cloud Hosting UK and VMware Hosting. If you are interested in our services please call us for chat on 0800 612 2524

How to Run a stored procedure on a linked server and fetch the data on SQL Server 2005#

This is carried out by using openquery, setup the linked server in server objects. Then call the server using a tabled-valued function#

CREATE FUNCTION p_get_closing_prices
(	
	-- Add the parameters for the function here
	@valueDate datetime
	
)
RETURNS TABLE 
AS
RETURN 
(

select * from openquery(SALD157, 'exec CreditPricer.dbo.p_get_closing_prices ''18 feb 2008''') 

	
)

Back to SQL Server