unable to add data on sql server 2000

Question

0.00/5 (No votes)

See more:

SQL-server-2000

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

Posted 11-Jun-13 19:46pm

Sanjay Kumar Chitrakar

Add a Solution

Comments

uspatel 12-Jun-13 1:56am

What is your transaction log size and did you check sql server log

Zoltán Zörgő 12-Jun-13 1:57am

What is the sql server edition? The MSDE edition had a 2GiB limit.

RedDk 12-Jun-13 12:54pm

Get SQLServer2008Express with Advanced Services, install it, and add .mdf and .ldf. From inside this edition it's possible to "context-menu" an outboard
scripting of what's in that database. Completely. Why not?

Maciej Los 12-Jun-13 17:20pm

Have you tried to shrink database[^]?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sanjay Kumar Chitrakar · Answer 1 · 2014-12-02T20:10:00

Solution 1

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.

Posted 2-Dec-14 20:10pm

Sanjay Kumar Chitrakar