链接服务器，结果查询xp_cmdshell到表迁移SQL Server 2005到SQL Server 2019

Question

我正在从Microsoft SQL Server 2005迁移过程到Microsoft SQL Server 2019，并且在尝试插入查询结果xp_cmdshell时被

。

卡住

INSERT INTO LOGTABLE (ShopNo,Line) SELECT 1, OUTPUT FROM openquery ([IP_LINKED_SERV],'set fmtonly off; exec master..xp_cmdshell ''type d:\log\file.log'' ')

了 错误：

msg 11519，第16级，状态1，程序
sp_describe_first_result_set，第1行[批处理启动行0]无法确定元数据，因为语句'exec master..xp_cmdshell'类型d：\ log \ file.log''调用扩展的存储过程。`

。 SQL Server 2019中的XP_CMDSHELL在链接服务器上，

EXEC ('set fmtonly off;exec master..xp_cmdshell ''type d:\log\file.log'' ') AT [IP_LINKED_SERV]

但是我无法将此结果插入表格

INSERT INTO LOGTABLE (ShopNo,Line) SELECT '998', OUTPUT FROM EXEC ('set fmtonly off;exec master..xp_cmdshell ''type d:\log\file.log'' ') AT [IP_LINKED_SERV]

靠近关键字“ exec”的语法不正确。

SQL2005中的一部分程序：

DECLARE TableCursor CURSOR FOR
SELECT IP, SqlUser, SqlPass, Object   FROM ..ObjectInfo

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @Ip, @SqlUser, @SqlPass, @Object
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @Object
SELECT @PARAMS = ' @tmp_object varchar(5) OUTPUT'
set @SQL = 'INSERT INTO LOGTABLE (Object,Line) SELECT @tmp_object, output FROM  openquery (['+@Ip+'],''set fmtonly off;
exec master..xp_cmdshell ''''type d:\log\file.log''''
'')' 

BEGIN TRY
EXECUTE sp_executesql @SQL,@PARAMS, @tmp_object = @Object OUTPUT
END TRY
BEGIN CATCH
INSERT INTO LOGTABLE (Object, Line) VALUES(@Object, '-error')
END CATCH```