SQL Server 2008:创建窗口句柄时出错 [英] SQL Server 2008: Error creating window handle

问题描述

我的数据库中有N个表，其中包含约60万条记录.我创建了一个SQL脚本，将这些数据复制到相同的表中(基本上，这是一个生成更多数据的脚本).我已经测试了该脚本，该脚本可以很好地处理小数据(10,000条记录).当我尝试复制所有数据时，它会引发错误:

I have N number of tables in my database, which holds around 0.6 million records. I've created a SQL script which copies this data into same tables (basically it's a script to generate more data). I've tested the script it runs fine for small data (10k records). When I tried it to copy all data, it throws an error:

执行批处理时发生错误.错误消息是:创建窗口句柄时出错.

An error occurred while executing batch. Error message is: Error creating window handle.

1.SQL Server中此错误的含义是什么?

1.What is the meaning of this error in SQL Server?

2.它是否需要对脚本中的SQL进行任何操作，还是这是SQL Server其他组件的原因?

2.Does it has to do anything with my SQL in script, or is this cause of other component of SQL Server?

推荐答案

句柄是用于管理OS资源的Windows工具.当计算机上的某些应用程序发生内存泄漏时-您可能用完了句柄，就会发生此错误.句柄的当前状态可以在任务管理器(句柄计数)中看到

Handles are Windows tools to manage OS resources. When some app on your machine have memory leaks - you can run out of handles and this error occurs. Current state of handles can be seen in Task Manager (Handle Count)

正如评论中所说-这是一个客户端问题.例如，大型结果集/查询输出到网格可能会导致此错误.

As said in comments - it's a client side issue. For example large resultsets/query output to grid may end up to this error.

解决方案:重新启动PC，最小化查询输出.您也可以尝试通过SQLCMD启动脚本.

Solution: Reboot your PC, minimize the output of query. Also you can try to launch script via SQLCMD.

有关您的更多信息，请在此处阅读.

More about you can read here.

一些解释此处.

这篇关于SQL Server 2008:创建窗口句柄时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！