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

简介: 在SQL Server中使用Multiple Server Query Execution这个功能做数据库维护或脚本发布时非常方便,昨天由于磁盘空间原因,删除清理了大量的软件和组件,结果导致SSMS客户端出了问题,重装过后,使用Multiple Server Query Execution时,出现了...

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.

 

 

 

clip_image001

 

 

 

出现这个问题,只需要在SSMS的选项(Options-> Query Results -> MultiServer Results -> Merge results 将这个选项的值从True值修改为False"值。

 

 

 

clip_image002

目录
打赏
0
0
0
0
35
分享
相关文章
Transparent Data Encryption Data Dynamic and Data Dictionary Views You can query a set of dynamic and data dictionary views to find more information about Transparent Data Encryption (TDE) data.
Transparent Data Encryption Data Dynamic and Data Dictionary Views You can query a set of dynamic and data dictionary views to find more information about Transparent Data Encryption (TDE) data.
86 2
【错误记录】Tinker 热修复示例运行报错 ( Execution failed for task ‘:app:tinkerProcessD‘ . tinkerId is not set!!! )
【错误记录】Tinker 热修复示例运行报错 ( Execution failed for task ‘:app:tinkerProcessD‘ . tinkerId is not set!!! )
362 0
【错误记录】Tinker 热修复示例运行报错 ( Execution failed for task ‘:app:tinkerProcessD‘ . tinkerId is not set!!! )
Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property manually
Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property manually
4827 1
Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property manually
DataGrip 2020.1连接数据库报错 Server returns invalid timezone. Need to set‘serverTimezone’property
DataGrip 2020.1连接数据库报错 Server returns invalid timezone. Need to set‘serverTimezone’property
310 0
DataGrip 2020.1连接数据库报错 Server returns invalid timezone. Need to set‘serverTimezone’property
Server returns invalid timezone. Need to set ‘serverTimezone‘ property.(idea连接数据库报错)
Server returns invalid timezone. Need to set ‘serverTimezone‘ property.(idea连接数据库报错)
222 0
Server returns invalid timezone. Need to set ‘serverTimezone‘ property.(idea连接数据库报错)
idea连接mysql数据库遇到Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezone‘ 。。。。。
idea连接mysql数据库遇到Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezone‘ 。。。。。错误显示及解决办法。
idea连接mysql数据库遇到Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezone‘ 。。。。。
IDEA连接数据库错误:Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezon‘ 错误
IDEA连接数据库错误:Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezon‘ 错误
191 0
IDEA连接数据库错误:Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezon‘ 错误
C - error: converting to execution character set:Illegal byte sequence
C - error: converting to execution character set:Illegal byte sequence
1516 0
C - error: converting to execution character set:Illegal byte sequence
AI助理

你好,我是AI助理

可以解答问题、推荐解决方案等

登录插画

登录以查看您的控制台资源

管理云资源
状态一览
快捷访问