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

相关文章
|
5月前
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.
46 2
【错误记录】Tinker 热修复示例运行报错 ( Execution failed for task ‘:app:tinkerProcessD‘ . tinkerId is not set!!! )
【错误记录】Tinker 热修复示例运行报错 ( Execution failed for task ‘:app:tinkerProcessD‘ . tinkerId is not set!!! )
289 0
【错误记录】Tinker 热修复示例运行报错 ( Execution failed for task ‘:app:tinkerProcessD‘ . tinkerId is not set!!! )
|
关系型数据库 MySQL 数据库
DataGrip 2020.1连接数据库报错 Server returns invalid timezone. Need to set‘serverTimezone’property
DataGrip 2020.1连接数据库报错 Server returns invalid timezone. Need to set‘serverTimezone’property
227 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连接数据库报错)
135 0
Server returns invalid timezone. Need to set ‘serverTimezone‘ property.(idea连接数据库报错)
|
关系型数据库 MySQL Java
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
4584 1
Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property manually
|
关系型数据库 MySQL Go
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‘ 。。。。。
|
Go 数据库
IDEA连接数据库错误:Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezon‘ 错误
IDEA连接数据库错误:Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezon‘ 错误
142 0
IDEA连接数据库错误:Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezon‘ 错误
|
IDE 开发工具
C - error: converting to execution character set:Illegal byte sequence
C - error: converting to execution character set:Illegal byte sequence
1191 0
C - error: converting to execution character set:Illegal byte sequence
下一篇
无影云桌面