I disagree. His email said it's always corruption in one particular table. Not in other tables. Aren't the chances something like 1 in 1,000,000 that a hardware/network issue happens to affect only that one table every time, and never any other tables? Granted that's still a small chance of probability ... But the situation that you and Bill describe (seems like the same situation) would affect random tables and random columns I'd think. Or did it always change only one single same table/column each time and never any others?
Karen > Not necessarily. > > > > Many years ago we were getting periodic corruption of table and column > names at one location. After much examination over a period of months I > finally figured out that characters were always being changed by the same hex > value. For instance, an ‘a’ would become a space or some other character. > But the difference between them in the ASCII chart was always the same. I > finally traced it to one PC that had the non-maskable interrupt turned > off. The NMI’s function was to detect memory corruption on the motherboard. > Well, we had flaky RAM in one spot. Since this was DOS, and since things > always loaded in the same sequence, the particular area of memory was always > holding the copy of file 1 in that region of memory. When the PC went to > update file 1 and the memory was in the wrong state, bad data was written > to file 1, either in SYS_TABLES or SYS_COLUMNS. > > > > Replaced the memory and all was well. > > > > Point it, it can absolutely be traced to something hardware or network > related. > > > > Emmitt Dove > > Manager, Converting Applicat > > >
