Ed,

a most interesting notion, I feel obliged to join you in having sneaky feelings (about this database) but, in this case, the structure is sound and the table and indexes are not corrupt...

that'll only work if you decided to create an output file for this job (which you probably didn't seeing as you're asking this question)...

what you probably want to look at...

you probably want to check out syscomments

First things first, setup performance monitor to alert you to when you are reaching your memory threshold and check if your cache is being flushed too.

Some suggestions:

 - have you...