SQL ServerMultiple Server Query Execution报The result set could not be merged..

在SQL Server中选取Multiple Server Query
Execution这一个效能做数据库维护或脚本发表时充足便宜,后天出于磁盘空间原因,删除清理了汪洋的软件和零部件,结果导致SSMS客户端出了问题,重装过后,使用Multiple Server Query
Execution时,出现了大气底下错误:

 

 

 

 

An error occurred while executing batch. Error
message is: The result set could
not be merged because the result schema did not match the schema from
the first responding server.

 

 

 

SQL Server 1

 

 

 

并发这多少个问题,只需要在SSMS的挑三拣四(Options)-> Query Results ->
MultiServer Results -> Merge results
将以此选项的值从“True”值修改为“False”值。

 

SQL Server, 

 

SQL Server 2

相关文章