objects

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Yanjie (yren_at_cc3.com)
Date: 03/05/04

Next message: Vicky: "Accessing Same Remote Table Form Two Linked Servers Return Different Results"
Previous message: lindawie: "Re: Merging two tables"
Next in thread: Sebastian K. Zaklada: "Re: objects"
Reply: Sebastian K. Zaklada: "Re: objects"
Messages sorted by: [ date ] [ thread ]

Date: Fri, 5 Mar 2004 10:37:23 -0800

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?

Next message: Vicky: "Accessing Same Remote Table Form Two Linked Servers Return Different Results"
Previous message: lindawie: "Re: Merging two tables"
Next in thread: Sebastian K. Zaklada: "Re: objects"
Reply: Sebastian K. Zaklada: "Re: objects"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Index Creation Date
... Mistake, mistake.. ... >>Join sysindexes and sysobjects and use the crdate in the ... Read details on SQL Server Books Online. ...
(microsoft.public.sqlserver.security)
Is there a way to indentify when a index was created?
... sysobjects but nothing like that in sysindexes. ... SQL Server 2000 EE ... sp3. ...
(microsoft.public.sqlserver.programming)