RogerCooper
Registered User.
- Local time
- Today, 14:19
- Joined
- Jul 30, 2014
- Messages
- 277
I have a table called Exception Reports which contains the names of various queries which are run twice daily as well as information about the query (who receives the e-mail, the date/time is was last run, the number of records returned, the first record etc.). After the query is run (and any e-mails or printouts needed are executed) the table is updated with information about the query. I have been doing this for many years without much trouble.
Recently, I have the database being corrupted frequently during normal runs. I put the Exception Reports table in its own database, but the errors continue (Putting it in its own database makes repairs much faster, however).
Does anyone have any ideas about how to reduce this problem. Would waiting after each record updates help?
Recently, I have the database being corrupted frequently during normal runs. I put the Exception Reports table in its own database, but the errors continue (Putting it in its own database makes repairs much faster, however).
Does anyone have any ideas about how to reduce this problem. Would waiting after each record updates help?