2540 Error

[Francesco]

We have numerous 2540 errors in our db. After running fix_al to fix the problem, should we re-run
NEWALLOC? Would it be necessary to do so if fix_al ran without errors? Just trying to figure when we
need to schedule this, and how much time this is going to take.

Thanks in advance.

[Sola]

Before you ran fix_al did you run CHECKDB to ensure no other areas where affected.
I don't think it is necessary to run NEWALLOC if CHECKDB did flag another problems


------------
Francesco at 2/16/00 2:41:33 PM

We have numerous 2540 errors in our db. After running fix_al to fix the problem, should we re-run
NEWALLOC? Would it be necessary to do so if fix_al ran without errors? Just trying to figure when we
need to schedule this, and how much time this is going to take.

Thanks in advance.