您可以为此使用OPENROWSET。看一看。我还包括了sp_configure代码,以启用临时分布式查询(如果尚未启用)。
CREATE PROC getBusinessLineHistory
AS
BEGIN
SELECT * FROM sys.databases
END
GO
sp_configure 'Show Advanced Options', 1
GO
RECONfigURE
GO
sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONfigURE
GO
SELECT * INTO #MyTempTable FROM OPENROWSET('sqlNCLI', 'Server=(local)\sql2008;Trusted_Connection=yes;',
'EXEC getBusinessLineHistory')
SELECT * FROM #MyTempTable