>Gar,
>
>You'd be better off using sp_helpindex to interpret the value of the sysindexs.status.
>
>Anyway... <s>
>
>Use the SEM or sp_helptext and examine the code for sp_helpindex.
>
>-Mike
I found still a better way for my purposes. sp_help 'mytable' and you get 8 result cursors with almost everything you would want to know about that table. This means I can get rid of all my custom queries against the system tables, and used microsoft store procedures and view the way microsoft reccommends. In theory, this should mean my utility will be usable across multiple version SQL server, but since this is Microsoft, I'm not going to bet on it.
Thanks
Gar W. Lipow