Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  very strange problem-please help

Author  Topic  ajay Starting Member 34 Posts Posted - 2001-07-07 : 05:20:25 I have a table in which records gets filled in by an application.In one shot about 200 records are inserted. This aplication runs twice every month. Till now every thing was working perfectly and now something strange has started happening. Initial 30-40 records do not get inserted in the table. For e.g out of 100 records, only 70 records get inserted leaving out initial 30 records. I ran the app again but the same thing happened, but this time it left more than 40 records uninserted,it inserted about 50 records and left 50 uninserted, I ran the app agin and this time it left 70 records and inserted only 30. This application has run for about 6 times(3 month). What I did was, I deleted all the records from the table and tried to run tha app again and this time to my surprise everything went allright, all records got inserted and started displaying on the site. But if this thing happens again, then I am gone for a toss as these records play very importamt role in our site and this app is scheduled to run at specific period. My database is of unrestricted file growth and it is automatic by 10 percent. What could be the problem, can somebody help. thanks yours truly ajay