mssql 链接突然异常报错

刷新视图
如果视图的底层表结构发生了变化(例如添加或删除了列),可以尝试刷新视图。使用以下命令:
sql
复制
EXEC sp_refreshview 'v_tbdTravelOkOther2';
这将重新绑定视图的元数据,确保其与底层表的结构保持一致


异常报错
Executed as user: rdsuser.
Cannot get the data of the row from the OLE DB provider "MSOLEDBSQL" for linked server "d_ter". [SQLSTATE 42000] (Error 7346) OLE DB provider "MSOLEDBSQL" for linked server "d_trer" returned message "Binding information is invalid.". [SQLSTATE 01000] (Error 7412). The step failed.

posted @ 2025-04-22 10:18  自在现实  阅读(23)  评论(0)    收藏  举报