Corrupted indexed view

Windows Server 2003
SQL Server 2000 Enterprise
One of our indexed views is periodically getting corrupted. When it
occurs, one of the aggregate money fields returns an incorrect value.
Rebuilding the view corrects the problem.
This is a financial system and these incorrect money amounts are
causing major problems. But removing the indexed view causes certain
summation functions of the system to be unacceptably slow.
How do I fix?You should probably contact PSS to get tot he root of the problem.
http://support.microsoft.com/defaul...id=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
Andrew J. Kelly SQL MVP
<thegap2@.excite.com> wrote in message
news:1129901119.648845.24860@.o13g2000cwo.googlegroups.com...
> Windows Server 2003
> SQL Server 2000 Enterprise
> One of our indexed views is periodically getting corrupted. When it
> occurs, one of the aggregate money fields returns an incorrect value.
> Rebuilding the view corrects the problem.
> This is a financial system and these incorrect money amounts are
> causing major problems. But removing the indexed view causes certain
> summation functions of the system to be unacceptably slow.
> How do I fix?
>