Hi, It's proc works fine, because I sill use in production.

SELECT sysobj.name object_name,

sysobj.xtype object_type,

...

Did You dbcc dbreindex on table?, If this not work, then Drop index ID1 (You can identify this index with sp_helpindex 'table' command)

and re-create index

And if this not Work,...

An Exceptional DBA MUST BE Perfectionist, because If you ignores details, you ignores the reality