Posted by John Bell on 06/02/05 23:20

Hi

That is because it is not really an index.

In BOL the documentation for sysindexes/Indid
255 = Entry for tables that have text or image data

I would have thought DBCC CLEANTABLE and/or DBCC CHECKTABLE would have
mopped it up, but it doesn't seem to.

John

"MrDom" <mr_dom_is@hotmail.com> wrote in message
news:1117728125.050213.13480@g14g2000cwa.googlegroups.com...
>I checked the the sysindexes for that database and I did infact find
> another index, with an indid of 255.
>
> It's strange that the index doesn't show up in enterprise manager, or
> DBCC doesn't update it and remove it from the sysindex table.
>
> Thanks for your help guys!
>

[Back to original message]