MSSQL Server数据库出现意外错误 [英] MSSQL Server database is giving unexpected error

问题描述

你好，

我有沉重的MSSQL数据库.我正在使用经典的asp.
现在，数据库开始出现以下错误.

1)
-------------------------------------------------- ----------
Microsoft OLE DB提供程序的SQL Server错误''80040e21''

多步OLE DB操作生成错误.检查每个OLE DB状态值(如果有).没有工作.
-------------------------------------------------- -----------

2)
-------------------------------------------------- ------------
Microsoft OLE DB提供程序的SQL Server错误''80040e31''

超时已过期
-------------------------------------------------- ------------

Hello,

I am having heavy MSSQL database. I am using classic asp.
Now days database started giving me following errors.

1)
------------------------------------------------------------
Microsoft OLE DB Provider for SQL Server error ''80040e21''

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
-------------------------------------------------------------

2)
--------------------------------------------------------------
Microsoft OLE DB Provider for SQL Server error ''80040e31''

Timeout expired
--------------------------------------------------------------

Please help me how solve this issue?

推荐答案

超时到期意味着时间太长，您需要优化查询.

Timeout expired means it''s taking too long and you need to optimise your queries.

这篇关于MSSQL Server数据库出现意外错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！