sql - 无法确定元数据，因为每个代码路径都会导致错误；请参阅其中一些以前的错误

Question

我正在从 SQL Server 2005 迁移到 SQL Server 2014，其中一个查询在 SQL Server 2014 中停止工作:

select * 
from openrowset ('SQLOLEDB','Server=(local);TRUSTED_CONNECTION=YES;',' exec [MyDatabase].[dbo].[MyTable]')

我收到以下错误消息:

Msg 11529, Level 16, State 1, Procedure sp_describe_first_result_set, Line 1
The metadata could not be determined because every code path results in an error; see previous errors for some of these.

Msg 4902, Level 16, State 1, Procedure sp_describe_first_result_set, Line 1
Cannot find the object "#MyTempTable" because it does not exist or you do not have permissions.

dbo.MyTable和 #MyTempTable不是真名。

什么可能导致此错误？任何帮助，将不胜感激。

谢谢

Answer 1

从 SQL Server 2012 开始，您需要使用 WITH RESULT SETS明确描述结果集:

EXEC('exec [MyDatabase].[dbo].[StoredProcedure] WITH RESULT SETS (( val SMALLINT));')