Sounds like you experience corruption quite often. If so, a detection tool is not what you want, but rather you should find out what is causing the corruption. There's an article on my web site that will get you started.
>I want to detect if one of my table in the database is corrupted before proceding to transaction.
>
>Anyone who knows a function or program that will detect a corruped index of a particular table? What i want in my application is a diagnostic tool to detect possible data corruption.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer