Error:7884,Severity:20,State:1(二)

2015-07-24 11:30:03 · 作者: · 浏览: 13
Rows+=1} "Read $ReadRows rows." # 关闭连接 $SqlReader.Close() $SqlCnnectionQuery.Close()

故障处理:

对于修改了数据类型的列,将数据重新更新就可以解决 问题(UPDATE 表 SET 修改的列=修改的列)

这个问题测试了 SQL Server2008 到 2014,都存在问题。其中 SQL Server 2008 R2 SP3中测试,SQL Server日志中的错误信息有所不同,是:

Error: 7886, Severity: 20, State: 2.

A read operation on a large object failedwhile sending data to the client. A common cause for this is if the applicationis running in READ UNCOMMITTED isolation level. This connection will beterminated.