Dataset corrupted

[Jed Fletcher]

I have a backoffice that runs 24/7 and every once in a while my
dataset gets corrupted. Once this happens none of my reports can be
shown and i cant use any of my forms that have datasets. Has anyone
else had this problem. Please any suggestions welcome.

 

[Gregory A. Beamer]

I have a backoffice that runs 24/7 and every once in a while my
dataset gets corrupted. Once this happens none of my reports can be
shown and i cant use any of my forms that have datasets. Has anyone
else had this problem. Please any suggestions welcome.

Not enough information to help.

Look at the event log and see if there are any error messages. If so,
work on the messages to find the root of the problem. Profiling SQL
Server may help determine the error, as well.

Unless you are caching the DataSet or storing it outside of the
database, it is unlikely the true root of the problem.

Peace and Grace,

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************