无法在sql server 2000上添加数据 [英] unable to add data on sql server 2000

问题描述

我使用的是10年前开发的银行软件。

数据库在ms sql server 2000中此应用程序在窗口服务器2000上运行。

现在数据库的大小超过2 GB。



自上两天以来，我可以创建新的客户帐户，但无法为此创建新的分类帐。当我在输入分类帐详细信息后单击输入时，它就会挂起。之后什么也没发生。我确实等了一个小时但没有任何事情发生。最后我不得不从任务经理那里停止它。



错误日志也没有显示任何相关内容。



请帮帮我，如果可能的话

Hi,

I am using an bank software which was develop 10 years ago.
Database is in ms sql server 2000 and this application is running on window server 2000.
Right now size of database more than 2 GB.

Since last two days i am able to create new customer account but unable to create new ledger for that. When i click on enter after entering ledger detail, it just got hang. Nothing happen after that. I did wait for an hour but nothing happen. At last i had to stop it from task manager.

Error log also not showing anything about that.

Please help me with it, if possible

推荐答案

感谢您的评论，现在问题解决了....

其实这个数据库是在12年前创建的，并且主键没有分配给表，这就是问题发生的原因.... :)再次感谢。

Thanks for you comments, Problem is solved now ....
Actually this database was created 12 years ago and primary key was not assigned to tables, that's why issue occur.... :) thanks again.

这篇关于无法在sql server 2000上添加数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！