>Hallo Everybody,
>
>We have developed a applicaiton for one of our customer, the data
>base size is about 40MB all put together, nowadays we are facing
>lot of index corruption problem. Everyday morning we are doing
>recreating the index. Is there any solution, to identify this
>problem. What is the cause for this index corruption.
>
>We are using UPS also.
>
>Regards
>
>Logamoorthy
There are many things that can cause corruption. There is a KB article on my web site that may help you.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer