objects

How to find the invalid and corrupted objects in
sql server 2000?
I tried sysindexes and sysobjects tables. Checked the
STATUS column, but didn't understand the values assigned
by Microsoft. Which number means IVALID or Corruption?> How to find the invalid and corrupted objects in
> sql server 2000?
See DBCC CHECKDB and DBCC CHECKTABLE in BOL for starters
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.