Nice, it answers my question :

I have seen in the stored proc that status comes from sysindexes.status

and your link shows how to analyse it :

case when (i.status & 1)<>0 then...

Thanks a lot for this link. It answer my question.

I have seen in the stored proc that status comes from susindexes.status and the code in your link shows how to...

Ok, status comes from sysindexes.status :

select i.name, i.status, ...

from dbo.sysindexes i ...

and sysindexes.status is documented as 'Internal system-status information'

So, no information about format.

Daniel

The only SQL statement I've seen is :

EXECUTE sp_MShelpindex N'[dbo].[Client]' , NULL, 1

I don't know what the column 'status' contains.

When ignore_dup_key is on 'status' contains 16810243 otherwise '16810242'

I suppose 'status'...

already done... I have seen nothing about that property

INDEXPROPERTY doesn't return information for ignore_dup_key and I have seen nothing in sp_help documentation.

But Enterprise Manager returns that information and I don't find how...

Daniel